Category Axis - Automatic Scaling Question

  • Thread starter Thread starter Marcia
  • Start date Start date
M

Marcia

A friend of mine does a lot of charting work and has used Quattro Pro
in the past. He has recently begun working in Excel and has found the
transition to be quite smooth... with one exception:

One of his frequently-used chart templates contains the dates of the
month along the category axis. The initial charts shows **every**
date (1, 2, 3, etc.), but he must frequently condense the scale of the
axis to display varying scales (ie., every 3 days, every 5 days, etc.)
and back again.

In Quattro Pro, he was able to automatically maneuver the axis scale
very quickly, but he has not found a way to do this in Excel.

It's really bugging him... doesn't anyone know how to do this?

Thanks!
Jessi
 
He can double-click the x-axis, and on the Scale tab, change the Major
Unit from 1 to 3 or 5.
 
Also, if the axis is Time Scale rather than Category, it will be easier
to adjust (Chart menu - Chart Options - Axis tab - Category Axis options).

- Jon
 
Back
Top