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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top