If I have data for varying times in a column chart, how do I space

[Guest]

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.

 

[Tushar Mehta]

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