How Do I Make multiple Pie Charts

J

jebert

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.
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I: If Pie Section Label = X, Make Pie Section Color = Y 2
Pie Charts 1
Need Help Summarizing Survey Results 1
How to create multiple bar charts at the same time? 0
Import of 50+ Survey Data Results 5
Column Data to Rows 4
Creating Multiple Pie Charts from Excel Sheet 1
Pivot Table HELP 2

Top