Can you use autofilter and a graph together?

  • Thread starter Thread starter Devill_Dog
  • Start date Start date
D

Devill_Dog

I'm trying to use autofilter to select a single line of data (the
uppermost) then graph it. Unfortunately When I select the source data
for my graph (A4 through IH4) then use autofilter it doesn't select the
top row of data, instead it still graphs the same row targeted before
the filter process. How do I get it to graph the row beneath my
autofilter drop down list?

In a nutshell, can you use autofilter to select the line of data you
wish to graph?

Thanx in advance!
 
You can create a chart from all the data in the table. Then, filter the
data to show only the row you want displayed in the chart.
 
Believe I tried that and got an error about having reached series limit.
Wouldn't plotting 2000 rows with each row having 250 data points take
forever? Thanx for the reply!
 
Checked on it and 255 is the limit to the number of series to be plotted
at once. Can the filter you mentioned be used before the actual plot
occures?
 
Back
Top