+ Reply to Thread
Results 1 to 3 of 3

How to line chart to display the dates on x-axis evenly with unequal data intervals?

  1. #1
    Registered User
    Join Date
    03-14-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    20

    How to line chart to display the dates on x-axis evenly with unequal data intervals?

    Hi guys,

    This one should be an easy one for you out there, but I just couldn't quite figure out.

    The problem with the data is that the data points reduced to only 2 per month after April. So if I plot this on a line chart, the X-axis will have unequal spacing towards the end, it will be very crowded.
    I was thinking of smoothing the data or interpolating it. But since this is financial pricing data, we want the realistic picture of it. Smoothing doesn't reflect the realistic performance of this financial product.

    My question is: Is there a way to make the X-axis equally spaced?

    Thank you.

    dates x axis.PNG


    I have a set of financial data sample with dates that looks like this:

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,338

    Re: How to line chart to display the dates on x-axis evenly with unequal data intervals?

    It is not clear to me exactly what you have and what you want.

    Are your dates real dates or are they text strings that look like dates? Is your line chart using a category/text axis or a date axis? If I had to guess, I would guess that the problem is that you are using a category/text axis (perhaps with dates that are really text strings that only look like dates). What I think you want is a date axis (should be able to change using the format axis dialog), and you may need to make certain that your dates are real dates.

    This is a little dated, but it explains the differences between the different axis types that Excel uses: http://peltiertech.com/Excel/ChartsH...ValueAxis.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    03-14-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: How to line chart to display the dates on x-axis evenly with unequal data intervals?

    Hey,

    sorry for my messed up question.

    The dates are strings. You can convert them to numbers. So, it's not plain text.

    The only problem is that I don't have enough data points towards the end to make the axis look evenly spaced out.

    You're saying that I have to convert those text string to real dates so I can put them on the x-axis?
    But doesn't the result look the same? unless I artificially add data points between those crowded dates.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 09-14-2014, 11:07 AM
  2. unequal intervals for stacked bar chart
    By guthrie in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 09-03-2014, 04:26 AM
  3. Unequal intervals in x-axis values
    By Paul-NYS in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-01-2013, 06:50 AM
  4. Replies: 2
    Last Post: 04-01-2013, 12:49 PM
  5. line chart-format x axis for dates
    By Scatter in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-29-2011, 04:59 AM
  6. How to Plot Scatter Diagram with unequal/ arbitrary dates on X axis
    By ranjana in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-07-2010, 02:16 AM
  7. Variable dates on X axis evenly spaced (should not be)
    By Leo Bueno in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-24-2005, 12:05 PM

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