View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ElPresidente ElPresidente is offline
external usenet poster
 
Posts: 8
Default Graphing the sum of an autofilter result

Let's say the data is laid out as follows:

Group 1 $20
Group 2 $20
Group 1 $20
Group 3 $20

If I filter the data by Group1, I will get two rows back. I want to
graph all the rows for that group into one data series on the graph.
I'm thinking I could create a temporary sum row, but there has to be
an easier way?