+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    tc1967uk
    Guest

    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. #2
    Tushar Mehta
    Guest

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

    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 <94AF9A6D-D1C3-48F5-B927-E1DDC2192140@microsoft.com>,
    tc1967uk@discussions.microsoft.com 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1