Software

Ask something
Discussion Locked

EXCEL GRAPH

0 helpful
5 replies

by chitosunday

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
My graph in x shows monthly trending of our sales from April 2002 to April 2003. However, when i viewed my chart, it does not show all the months. Sometimes, the month of may is missing. I check my source data and the month of may exist. I think if the graph is too long it truncates some of the months to fit. How can i manually forced excel to show all the month?

5 replies

by jgr

Sir
First what type chart are you using Bar or Line?
I use a very simple Data set have built graphs with no problems.
I have always isolated The on a seperate work sheet and then built the graphs. months down, Data across
Sales
Jan XXX
A line chart will yeld a good chart.

Jim.

by firstpeter

Try right-clicking on your X axis and selecting "Format Axis". Set your major unit on the Scale tab to 1 month. That should force all the months to show, although you may have to adjust the font size and/or chart size to make sure it all is visible and readable.

This discussion is closed to new replies.