brigitte2000
New Member
- Joined
- Mar 17, 2009
- Messages
- 1
Hi
I hope this can be done. I've got a set of data on one sheet and want to generate charts from them (i.e. bar charts). I also have more or less the same information for 22 other sheets - so I have to do 15 charts on one sheet by 22 sheets... Is there a macro that can help me do this? I was thinking I could copy one chart across and then change the source data, but that still takes a long time.
Help please!!!
Thanks.
Bridget.
I hope this can be done. I've got a set of data on one sheet and want to generate charts from them (i.e. bar charts). I also have more or less the same information for 22 other sheets - so I have to do 15 charts on one sheet by 22 sheets... Is there a macro that can help me do this? I was thinking I could copy one chart across and then change the source data, but that still takes a long time.
Help please!!!
Thanks.
Bridget.