Results 1 to 2 of 2

Thread: Data points in Excel chart not lining up with axis

  1. #1
    Join Date
    Mar 2010

    Data points in Excel chart not lining up with axis

    I am using Excel 2007. I have made charts that have dates as the x-axis and numerical (cummulative) values for the y axis.

    The lines go up as they should, but the dates don't line up properly. They y-value lines up with 4 months before it actually happened.

    I have added more dates and values after initially creating the chart. The plot area updates, but the x-axis doesn't. I have tried changing the distance between tick marks, intervals for the dates showing, making the chart bigger and smaller, selecting the date data range, etc. I am out of ideas for how to make them match.

    Any help would be greatly appreciated!

  2. #2
    Join Date
    Aug 2011

    Re: Data points in Excel chart not lining up with axis

    You can try below mentioned steps to get the requirement of yours.
    • You should go for Chart and after that click on Chart Tool and click on Design on the Ribbon.
    • Now go for Select Data.
    • After that click on Hidden and Empty Cells
    • After that click on Connect data points with line
    • Finally click on Ok button.

Similar Threads

  1. Setting Chart Data points with an array?
    By CodeKid in forum Software Development
    Replies: 2
    Last Post: 03-07-2012, 09:33 PM
  2. There is no data in Excel Pie Chart
    By Tarani in forum MS Office Support
    Replies: 2
    Last Post: 25-02-2012, 11:57 AM
  3. Replies: 3
    Last Post: 25-02-2012, 11:55 AM
  4. Replies: 1
    Last Post: 25-02-2012, 11:01 AM
  5. Mark data points in Excel line chart
    By Amie in forum Windows Software
    Replies: 3
    Last Post: 11-06-2009, 07:20 PM

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Page generated in 1,638,033,159.29855 seconds with 17 queries