Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Linear time axis on line chart
Hello, I want to have a linear time axis along the bottom of my chart, and
to display some values associated with a series of events and to have their position on the axis grouped and spaced by the time that they occured. This means that if I had three things happen at 9:15, 9:30 and 10:00 on monday, then another event at 9:00 on Tuesday, the values for the first three would appear in quite close proximity along the axis, then a fairly large gap before the next one. - does that make sense? I can nearly get what I want with a scatter chart, but some of the events will have one or two of the associated values missing and the scatter chart leaves a gap where there is no value, instead of just linking it up with a line to/from the previous one. And I need to show a continuous trend. Is this possible? Thank you for your help. M |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Linear time axis on line chart
Hi,
Since you have both dates and times and you want the spacing to reflect the temporial nature of the data your best choice is probably scatter. Now select the chart and choose Tools, Options, Chart tab, and set Plot empty cells as Interpolated. If this helps, please click the Yes button. Cheers, Shane Devenshire "Michelle" wrote: Hello, I want to have a linear time axis along the bottom of my chart, and to display some values associated with a series of events and to have their position on the axis grouped and spaced by the time that they occured. This means that if I had three things happen at 9:15, 9:30 and 10:00 on monday, then another event at 9:00 on Tuesday, the values for the first three would appear in quite close proximity along the axis, then a fairly large gap before the next one. - does that make sense? I can nearly get what I want with a scatter chart, but some of the events will have one or two of the associated values missing and the scatter chart leaves a gap where there is no value, instead of just linking it up with a line to/from the previous one. And I need to show a continuous trend. Is this possible? Thank you for your help. M |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line chart - time series - category axis date format (2007 VBA) | Charts and Charting in Excel | |||
Time Series Chart Data Plot Line ''Disappears'' When Y Axis Formating Is Changed | Charts and Charting in Excel | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
stock chart non-linear y-axis | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel |