Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If I have data for varying times in a column chart, how do I space
I have speed data for various times of the day, but I need to space them out
equally in the chart so people viewing the chart can see when the busy times of the road are. Can anyone help. |
#2
|
|||
|
|||
If you are using anything other than a XY Scatter chart, you will have
to create the spacing yourself. For example, if you have data for 7:00, 7:15, 7:30, 8:00, 9:00, and 9:30, note that the smallest interval is 15 minutes. Hence, reorganize the data as: 7:00 data-for-7:00 7:15 data-for-7:15 7:30 data-for-7:30 {empty cell} 8:00 data-for-8:00 {empty cell} {empty cell} {empty cell} 9:00 {empty cell} 9:30 Now, plot both columns ensuring that XL treats the first column as the x-values. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have speed data for various times of the day, but I need to space them out equally in the chart so people viewing the chart can see when the busy times of the road are. Can anyone help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Copying the contents of a column into a chart | Excel Worksheet Functions |