How to plot only visible autofiltered rows in a data list

C

Craig

I have a couple columns of data (about 500 rows). I apply autofilter to that
data, which filters it down to 100 rows of data. These rows are not
sequential. I would only like to plot this filtered list of data in a chart
 
A

Andy Pope

Hi,

If the chart is based on all the rows and the chart option Plot Visible
Cells Only is enabled ( Tools > Options > Chart ) then when the filter
is applied the chart should only display the 100 filtered rows.

Cheers
Andy
 

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

Data points in chart incorrect 0
Cell data entering slow! 0
Non Linear Scatter plot, need to find y value 3
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
XY scatter plot with more than 32000 rows in Excel 2003 0
Drop down list control value in vba 2
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Plot hysteresis plot in Excel 2013 0

Top