how to plot filtered data only (2003)

[dubdub]

hi all,
say you have a huge data, you did filtering and you want to plot the filtered data only, without copying it and pasting into a different sheet.
Thanks in advance.

[HansV]

If you create a chart based on the original, unfiltered data, then apply a filter (using AutoFilter or Advanced Filter), Excel will automatically adjust the chart to show only the filtered data.

[dubdub]

Thanks HansV.