Microsoft Office Tutorials and References
In Depth Information
Changing the scale of a category axis
example, if you plot a column chart for dates at the beginning of April, May, August, and
September, Excel gives you something that looks like this:
The markers for August and September are moved to the positions they would occupy
if data for June and July were included—and, in fact, Excel creates labels for the missing
dates, perhaps on the assumption that you will supply the missing data later. Excel will also
sort the chart in chronological order in the event that the worksheet data is not sorted.
Ordinarily, Excel knows whether an axis should be time-scaled or not and proceeds
accordingly. As the following illustration shows, Excel’s default Axis Type option is Automatically
Select Based On Data:
There might be occasions when you want to override Excel’s decision and convert a date
axis to a text axis. In the preceding example, if you don’t intend ever to ill in the missing
months, you might prefer an evenly spaced, text-based chart, which would look like this:
Search JabSto ::




Custom Search