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

L

LouO

This has happened several times and every time I have to rebuild the charts
from scratch because the columns become almost invisible.
 
J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top