| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart for hidden rows?
I am feeling some trouble!
I have a Bar Graph based on a data table based on Subtotals & Grouping! Whenever the first level of Grand Total is selected the chart's bars vanish! Any idea how to overcome this problem. Thanx in advance! -- Best Regards, FARAZ A. QURESHI |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Chart for hidden rows?
Hi,
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 "FARAZ QURESHI" wrote in message ... I am feeling some trouble! I have a Bar Graph based on a data table based on Subtotals & Grouping! Whenever the first level of Grand Total is selected the chart's bars vanish! Any idea how to overcome this problem. Thanx in advance! -- Best Regards, FARAZ A. QURESHI |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Chart for hidden rows?
"Andy Pope" wrote in message
... Hi, Select the chart and then use the menus Tools Options Chart Uncheck 'Plot visible cells only' Cheers Andy Thank you - I, too, had a chart using what would ordinarily have been a hidden column. I'm new to charting so, not stopping to look, took the "easier?" way out - white font color and shrunken column width. This is much better. Geo. S. |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Chart for hidden rows?
I have rows not showing in a spread sheet. I tried the HELP suggestion, same
as yours (TOOLS, OPTIONS) but the "Plot visible cells only" check box isn't checked. Where are my missing rows? How do I find them? -- dobiegillis "Andy Pope" wrote: Hi, 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 "FARAZ QURESHI" wrote in message ... I am feeling some trouble! I have a Bar Graph based on a data table based on Subtotals & Grouping! Whenever the first level of Grand Total is selected the chart's bars vanish! Any idea how to overcome this problem. Thanx in advance! -- Best Regards, FARAZ A. QURESHI |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula or Code to keep Hidden Rows Hidden | Excel Worksheet Functions | |||
| I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
| Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
| Hidden data - hidden chart | Charts and Charting in Excel | |||
| deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
Hybrid Mode
