Drawing a chart over a filtered data source

F

foley

Hi

How to draw a chart, using only the first 20 rows of a filtered list?

Some restrictions:
- the criteria for filter varies, the chart should react and plot the
new data
- the list contains serveral thousand entries
- using a filter or not, only the first 20 rows should be plotted


Thanks for any hint
Axel
 
D

Debra Dalgleish

You could add a column to the table, with a SUBTOTAL formula. For
example, in cell A2, use the formula

=SUBTOTAL(3,$B$2:B2)

where column B will have an entry in every row. Copy the formula down to
the last row of data.

On another sheet, list the numbers 1-20 in column A, and enter the
headings for the columns you want to use in your chart.
A B C
Date Qty
1
2
3

Use vlookup formulas to pull the data from the filtered table, e.g.:

=VLOOKUP($A2,DataTable,2,FALSE)

Create the chart from this table.
 
Top