| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Why the hidden column can't be shown on charts?
It is strange that when the data is quoted from a hidden column, the data
can'be showed on charts. is it one default excel charts properties? I'm not farmilia with excel chart. does anyone can help me let this data shown on charts? Thanks and regards, Viesta |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Why the hidden column can't be shown on charts?
Hi,
It is an option. in xl2003 select the chart and then use the menus Tools Options Chart uncheck Plot visible cells only Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "ViestaWu" wrote in message ... It is strange that when the data is quoted from a hidden column, the data can'be showed on charts. is it one default excel charts properties? I'm not farmilia with excel chart. does anyone can help me let this data shown on charts? Thanks and regards, Viesta |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine Clustered Column Bar charts and Stacked column bar charts | Charts and Charting in Excel | |||
| Column of Text Shown = Total Times Shown? | Excel Worksheet Functions | |||
| Excel: copy and paste only shown not hidden cells into new sheet | Excel Discussion (Misc queries) | |||
| Excel:a column of numbers,I want the highest shown automatically? | Excel Discussion (Misc queries) | |||
| Named Ranges shown (or not shown) as blue means what? | Excel Worksheet Functions | |||
Hybrid Mode
