Excel 2010 Graph Axis incorrect

Hi Experts,

I am new to 2010 and can't figure out why my date axis won't conform to my actual data points.  Excel keeps putting the date at the first of the month, however, my data points are at the end of the month.  I keep playing with the axis formatting and can't seem to get the axis to correspond to month end dates.

Who is Participating?
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
You can select any part of a chart by clicking the chart, then use the Chart Tools > Layout ribbon. On the very left there is a drop down for all chart elements. Select the X axis and then click "Format Selection".

With a category axis, you need to select just the populated cells if you want the data points to expand to the width of the chart.
Rory ArchibaldConnect With a Mentor Commented:
Try changing the axis type to a category axis and not timescale
grmcraAuthor Commented:
...thanks, however, it changed to the attached and now I can't seem to select the axis to figure out how to distribute the axis across the entire graph.
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
... nothing attached ....
grmcraAuthor Commented:
..oops, sorry...
Rory ArchibaldCommented:
A workbook would be more useful so we could see the settings and ranges in use ;)
grmcraAuthor Commented:
Between the two answers I was able to fix it, but I had to start over, for some reason I couldn't seem to edit the original chart.  Thanks!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.