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.

Thanks!
grmcraAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rory ArchibaldCommented:
Try changing the axis type to a category axis and not timescale
0
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.
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
... nothing attached ....
0
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

grmcraAuthor Commented:
..oops, sorry...
Capture.JPG
0
Rory ArchibaldCommented:
A workbook would be more useful so we could see the settings and ranges in use ;)
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.