Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
charting a filtered list
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
charting a filtered list
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
charting a filtered list
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
charting a filtered list
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 |
#5
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 |