How can I display multiple series in a pie chart?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AncientPC - 29 Nov 2004 10:21 GMT

Here's an example data / chart spreadsheet:
http://temp.ancientpc.net/po/piechart.xls

Ideally what I want to do is force the pie chart to use the most recent /
lowest data series through some way of calculating the lowest non-empty cell
location, but I don't know if that's possible.

If not, I just want to be able to choose which data series to plot. Even
though at the moment there's 8 series available under Chart -> Source Data,
it will only plot series 1 in the pie chart.

Reply to this Message

Andy Pope - 29 Nov 2004 11:21 GMT

Hi,

A pie chart will normally only display a single data series. It can be
manipulated to display 2.

For your particular problem you need to use a helper column that
contains one of the 8 data series. Through use of worksheet functions
and a control to allow easy use selection.
Check Jon's example and modify to suit you pie chart and data.
http://peltiertech.com/Excel/Charts/ChartByControl.html

Cheers
Andy

> Here's an example data / chart spreadsheet:
> http://temp.ancientpc.net/po/piechart.xls
[quoted text clipped - 6 lines]
> though at the moment there's 8 series available under Chart -> Source Data,
> it will only plot series 1 in the pie chart.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message