why do my column charts disappear

O

OrgLeadDog

I have column charts in my workbook but as I am adding some data, the charts
disappear and become lines. Why?
 
J

Jon Peltier

You mean they look like vertical toothpicks? Probably you have a date axis,
and intermittent (e.g., weekly) data. The axis still has slots for each day,
even if there is no data point, so the columns become narrow. Change to a
category (text) axis.

Excel 2003: Chart menu > Chart Options > Axes tab, select Category under
Category (X) Axis.
Excel 2007: Right click axis > Format Axis > main tab > halfway down, select
Date Axis.

- Jon
 

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