Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I want to make a graph that has the x-axis labels a full 24 hour period. I
have data points at random times during the day and I want to express that in the graph. For example, if I have 5 at 7:00, 2 at 7:40, and 3 at 11:00, I want it to show that the 5 and 2 are closer together than the 9, for example that there were more occurances at 7, none between then, and 1 at 11:00? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
In a bar (or column) chart, the x-axis is a <category axis not a numeric
one. This means the x-values are treated as text and each is equally spaced from the other. You might consider an XY chart with 100% negative y-axis error bars. Or look at Jon's waterfall charts: www.peltiertech.com best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "evan" wrote in message ... I want to make a graph that has the x-axis labels a full 24 hour period. I have data points at random times during the day and I want to express that in the graph. For example, if I have 5 at 7:00, 2 at 7:40, and 3 at 11:00, I want it to show that the 5 and 2 are closer together than the 9, for example that there were more occurances at 7, none between then, and 1 at 11:00? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Want graph with 2 axis, but bars overlap when second axis added | Charts and Charting in Excel | |||
Scaling time on the x-axis of a graph | Excel Discussion (Misc queries) | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
day of week and time on X axis of a graph | Charts and Charting in Excel | |||
Time axis column and scatter/line graph | Charts and Charting in Excel |