Plot a graph for each row in a sheet

[Dave Munday]

I hope sombody can help with a task I am working on for a colleague at work,
we would like to produce a chart for each row in a worksheet,

we do no know how many rows there will be , each row does have a given
length

an example of the data looks like this

Name Data
A B C D E

Dave Munday 7G 1 2 3 5 4 1 4 4 3 2 5 1 2 5 1 ..... 23 45 12 11 10



For each row as described above we would like to plot the values 23 45 12
11 10 against A B C D E and use Dave Munday 7G as the graph label


I hope I have explained myself enough

thanks for anytime you can spare to help with this issue

 

[Earl Kiosterud]

Dave,

You can do one of two things:

1/2 Make charts in advance. After making the first, copy it (Ctrl-drag it,
or Copy/Paste it), then change the Data Source. The chart title can be made
to dynamically get the name from the appropriate column. Now when the data
appears, the charts will reflect it. One problem is what to do with extra
charts for unused rows. If you've put in more charts then you'd ever expect
to need, you could manually delete the unused ones. It's a bit sloppy, but
is a lower-tech solution.

2/2 Write a macro that makes the charts. Lurk around
microsoft.public.excel.charting. Jon Peltier is the local charting guru,
and does a lot of macro stuff with them.

3/2 Use a single chart with multiple series (one for each row). That's the
usual approach for similar data.

 

[Dave Munday]

Earl
many thanks for your suggestions, I'll take a look in m.p.e.charting, I will
have 800 rows - the workbook feeds from an access data base which hold a
questionnaire for all 800+ pupils at our School

Regards

Dave