Excel Chart Options (Axis)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Under Primary Axis - What is the difference between Category and Automatic?
Category (X) axis
-Automatic
-Category
 
There are two types of category axis: Category and Time-Scale. If
Automatic (the default case) is selected, Excel guesses which to use
based on the data. In your case, Excel guessed Category for Automatic.
If your X values were dates, Excel would have guessed Time-Scale, but it
would still say Automatic until you changed it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top