+ Reply to Thread
Results 1 to 2 of 2

Thread: x,y ploting

  1. #1
    Registered User
    Join Date
    07-11-2007
    Posts
    4

    Question x,y ploting

    I have a series of dates in one column in order, but not in regular intervals.
    In a corresponding column I have values.

    If I select the values column and chart it, the graph has evenly spaced columns (naturally).

    How do I get the intervals on the graph x-axis to be 'spaced out' to represent the correct date intervals?

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Posts
    1,071
    Use an XY (aka scatter) plot. Select both the value column and the dates column->Insert->Chart. Then work through the chart wizard, being sure to select XY scatter in chart type, and make sure, when you get to the source data step that it is correctly assigning the dates to the x values.

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.2.0