LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Automatically Create Scatter Plot Charts Chris Gregory Charts and Charting in Excel 8 October 13th 06 03:35 AM
Macro to create charts? Ed Charts and Charting in Excel 2 September 25th 06 08:49 PM
How do I create charts that change source data automatically? cbalster Charts and Charting in Excel 0 May 26th 06 08:19 PM
Vb macro stops when I try to create more than 89 charts Tiberius Charts and Charting in Excel 0 January 19th 06 05:52 PM
Create charts that update automatically from data in rows Brent Charts and Charting in Excel 4 January 19th 06 12:50 PM


All times are GMT +1. The time now is 04:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"