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.

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

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

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

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