How can I use VBA to create multiple pie charts from a series of data

**johnskinner 3** · 05-24-2012, 06:43 AM

Hi

I need help creating multiple pie charts from a series of data, Basically there are 2 weekly totals that I need to make into a weekly pie chart, is there anyway I can do this without creating a chart for each individual week manually and having them produced automatically with a vba.

It would be a great help if anyone could help me.

Thanks

John

**Domenic** · 05-26-2012, 01:02 AM

Maybe something like this...

Please Login or Register  to view this content.

**Janc** · 10-26-2012, 01:17 PM

Sorry for the old thread revival (hope it's ok to do this?)

If the data is stored in rows rather than columns, how & where would the code above need to be changed?

Thanks in advance

**arlu1201** · 10-26-2012, 01:38 PM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.