why do my column charts disappear

  • Thread starter Thread starter OrgLeadDog
  • Start date Start date
O

OrgLeadDog

I have column charts in my workbook but as I am adding some data, the charts
disappear and become lines. Why?
 
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

Similar Threads

XL2007: line chart lines disappear when referenced workbook is not open 1
Why won't data hide? 3
How to create a custom line and column chart in excel 2007 1
Disappearing Data Label in chart 1
One extra x axis item that wont go away - can anyone help? 3
Cannot combine chart type error with only one chart. 8
How to chart months by financial year 0
My charts disappear when I save to PDF 1

Back
Top