View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
JDB JDB is offline
external usenet poster
 
Posts: 42
Default Is there a macro to create charts automatically?

Hi,

I have a sheet of data that relates to individual performance scores. Each
person has their data on one row which goes - Name, Team, Score 1, Target,
Score 2, Target, Score 3, Target, Score 4, Target.

I need to produce an individual graph for each person containing only the 4
score results. As there are over 120 individuals, is there a way, without
manually creating each one of using a macro or something to make chart
creation easier?