How can I display multiple series in a pie chart?

A

AncientPC

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.
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pie chart-remove series w/out changing percent in pie 1
How can I customise colours used in charts and keep those colours. 2
Not plot a data series in a chart but still display in data table 1
Bar of Pie Chart - 2nd Series 0
adding trendline to plots from multiple series 1
User Selectable Series and Number of Series for Line Chart 2
How to display both $ in pie chart and % in legend 1
For chart syles, why doesn't color order match series order? 1

Top