Why do the columns in my barchart shrink when changing the range?

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

Guest

This has happened several times and every time I have to rebuild the charts
from scratch because the columns become almost invisible.
 
Plotting dates? One value per week, say? The value is associated with only a day, so
it's going to get narrow as more weeks are piled on.

You could try changing the category axis type. From the Chart menu, choose Chart
Options, and on the Axes tab, change the Category Axis from Auto or Time Scale to
Category.

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