charting a filtered list

  • Thread starter Thread starter cathyh
  • Start date Start date
C

cathyh

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.
 
Select chart, go to Tools menu > Options > Chart tab, check Plot Visible
Cells Only.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables 0
Chart Title Using Autofilter Selection 6
Excel 2007 Pivot charts, any way to display filters on the chart? 1
control buttons for chart 1
Pivot table chart problem, How to show different subtotal levels 2
how do I show filter information on a pivot chart in excel2007? 3
CHART 1
JWalk Chart Tools and hidden row problem 1

Back
Top