Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Do I Make multiple Pie Charts
I have survey data of the following form:
Q1 Q2 Q3 Q4 ... Agree 20% 10% 40% 35% ... Neutral 50% 20% 30% 45% ... Disagree 30% 70% 30% 20% ... I want to create multiple pie charts on one page, one pie for each question showing the distribution of "Agree, Neutral, Disagree" responses for that question. I've done this by creating individual pies for each question and locating them on a single chart. There must be an easier way. Can anyone help? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Do I Make multiple Pie Charts
Hi,
There is no multi pie chart. You are already using the best approach of single charts embedded in a chartsheet. The only thing you could do to make it easier would be to write some VBA code to automate it. Cheers Andy jebert wrote: I have survey data of the following form: Q1 Q2 Q3 Q4 ... Agree 20% 10% 40% 35% ... Neutral 50% 20% 30% 45% ... Disagree 30% 70% 30% 20% ... I want to create multiple pie charts on one page, one pie for each question showing the distribution of "Agree, Neutral, Disagree" responses for that question. I've done this by creating individual pies for each question and locating them on a single chart. There must be an easier way. Can anyone help? Thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I make different charts the same size? | Charts and Charting in Excel | |||
How to make global changes to charts | Charts and Charting in Excel | |||
Charts - How to have multiple charts share a legend. | Charts and Charting in Excel | |||
how do I make multiple pie charts at the same time? | Charts and Charting in Excel | |||
How to I make custom pie charts? | Charts and Charting in Excel |