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
AncientPC wrote:
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.
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info