How can I display multiple series in a pie chart?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top