View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Tony Tony is offline
external usenet poster
 
Posts: 3
Default Grouping before entering into a chart

Is there a way of grouping data before using it in a graph.
I have data as follows


Red 2
Green 3
Red 1
Blue 1
Green 3


What I am after is for the graph to show three entries Red 3, Green 6, Blue
1

Any help would be apprieciated

Tony


PS. It's just for my sons football team scores - I just need to show how
many goals in each set of matches in a group