bar charts with time-spaced x-axis?

  • Thread starter Thread starter joandsp
  • Start date Start date
J

joandsp

does anyone know who to create bar charts where data is spaced on
x-axis? currently i have time data on x-axis and quantity on the y.
but the time data is evenly spaced rather than by the amount of time
that has passed. in other words, i want events which occured 1 hour, 3
hours and 10 hours apart to be spaced accordingly on x-axis. anyone
know how to do this?



------------------------------------------------




------------------------------------------------
 
Joan -

Excel has what they call a time-scale axis, but they should call it a
date-scale axis. It will spread out dates proportionally to the days
elapsed, but it puts all of the time points for a given date at midnight
at the beginning of the date.

You could fake it by putting the hours in the X data range, making a
chart with a time scale X axis, and changing your X axis number format
to something like "0" (a non-date format).

- Jon
 
Back
Top