Instead of doing that i suggest you make a pivot table with chart by making a
pivot chart you can filter the data as required and the chart will also be
drawn accordingly.
--
Thanks
Suleman Peerzade


"Enyaw" wrote:

I have a sheet with data that is autofiltered. I have subtotals on the data
by date. How do i graph only the subtotals?