Category Axis - Automatic Scaling Question

[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

 

[Debra Dalgleish]

He can double-click the x-axis, and on the Scale tab, change the Major
Unit from 1 to 3 or 5.

 

[Jon Peltier]

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