| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
why do my column charts disappear
I have column charts in my workbook but as I am adding some data, the charts
disappear and become lines. Why? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
why do my column charts disappear
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 ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "OrgLeadDog" wrote in message ... I have column charts in my workbook but as I am adding some data, the charts disappear and become lines. Why? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
why do my column charts disappear
"OrgLeadDog" wrote: I have column charts in my workbook but as I am adding some data, the charts disappear and become lines. Why? Thank you very much. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Charts and Shapes or Text Boxes that disappear | Charts and Charting in Excel | |||
| Why do series names on charts disappear when re-opening excel? | Charts and Charting in Excel | |||
| Drawing Objects disappear from charts | Charts and Charting in Excel | |||
| Pivot charts - data disappear after selecting or data are static | Excel Worksheet Functions | |||
| Combine Clustered Column Bar charts and Stacked column bar charts | Charts and Charting in Excel | |||
Hybrid Mode
