Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2003
    Clinton Twp., Michigan, USA
    Thanked 0 Times in 0 Posts

    Excell X Y Axis # format (2003/11.6355.6408 sp1)

    I want to show on the x axis of a chart (left side) the duration in minutes from 0 to 30 minutes ( 0.0.0 - 0:30.00). along the y axis (bottom) I have specific times that events occurred. The data in the chart will show the time a phone rang (time event occurred) , how long it rang before being answered (wait time) and duration of call, all in minutes. By plotting this data I can show the daily activities at specific times. I can get everything to plot except for the x axis. The range and scale will not do what I want. I have tried using a scatter chart but the x axis is giving me fits.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Excell X Y Axis # format (2003/11.6355.6408 sp1)

    Perhaps the attachment I just posted in <post:=555,657>post 555,657</post:> helps. Otherwise, could you post a small (anonymized) sample workbook?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts