Creating Multiple Pie Charts from Excel Sheet

[geezey]

Creating Multiple Pie Charts from Excel Sheet

I have an Excel sheet with the following:
-1 header row with the column names.
-5 individual rows of unique numerical data underneath.

How can I create 5 separate pie charts each using a separate row and
the header row without going through the chart wizard for each
separate row?

Needless to say, I have about 75 rows in the actual example.

Any suggestions?

 

[Pete_UK]

Once you have set up one pie chart, you can select this chart by
clicking on it (you should see small black squares in the corners and
midpoints of the chart area) then you can click <copy>, move the
cursor elsewhere and <paste> (or you can do a CTRL-drag off the chart
area). This will create a copy of the chart elsewhere in your sheet.

Obviously, this copy will still be looking at the same data range, so
you need to change this by right-clicking on the chart area and select
Source Data from the drop-down. Then repeat for the other ranges - not
too bad if you only have 5, but a bit tedious if you have 75 !! But
then, what would 75 pie charts look like on a single sheet?

Hope this helps.

Pete