| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
charting a filtered list
thank you!
"Dave Peterson" wrote: Select the chart Click on the "Select Data" option in the Data section of the chart tools ribbon. Click on the "Hidden and empty cells" Choose what you want. I found this by looking at xl2007's help for: hidden cells chart It was the top link. cathyh wrote: what about in xl2007? "Dave Peterson" wrote: In xl2003: Select the chart Tools|Options|Chart tab Check the "Plot visible cells only" box cathyh wrote: is it possible to chart a list that has been filtered via autofilter? my chart shows all data; even from the rows that the filter has hidden. -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Offset on a Filtered List | Excel Worksheet Functions | |||
| Summing a filtered list | Excel Discussion (Misc queries) | |||
| Totalling up a Filtered List | Excel Worksheet Functions | |||
| Edit filtered list | Excel Discussion (Misc queries) | |||
| Charting Filtered Data | Charts and Charting in Excel | |||
Hybrid Mode
