In any case, igpltcd has started you on the way to a happier data
experience. Have one main table containing all of your data. Use pivot
tables or other formulas to extract what you need for each chart, but keep
the main table intact for further analysis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Vishal Madhvani" wrote in
message ...
Hi,
Thanks for the reply.

Yes I will be adding more data to the Pie charts.
The gender was just an example to keep things simple.

This is part of my school coursework, and I would like to be able to do
some
cross analysis.

For example, In a Pie chart I would like to be able to show the
corrolation
between gender and if they are computer literate.

By using the first method in my previous post I loose the opertunity to be
able to make these kind of analysis.

Thanks

"igpltcd" wrote:


Vishal Madhvani;556171 Wrote:
I'm trying to create a Pie Chart from a list of Questionnaire results.
Each questionnaire's results will be recorded in a row.

For example, one of the questions is "Gender?" and I have asked 5
people.
Results: Male = 3, Female = 2



Is it feasible to create a separate table for this purpose and plot the
data on chart. Or you intend to club up more data on the same pie chart?




--
igpltcd