Can't get tick boxes to effect pie chart

Hi,

You'll need to upload the workbook so that we can see your request in context.

Hi,

Maybe you are misunderstanding the way charts work. What you have are three charts each with only one series. Normally you would have a single chart with three series, each one resulting in a bar but ON the SAME chart.

A Pie chart simply breaks a pie down into it's constituent parts, and hence by implication requires at least two series. With one series there is nothing to break down.

Hi,

I think you misunderstand what a pie chart is doing. It takes a population of values, say 12 months sales, and creates 12 pie slices for each month where the size of the pie reflects the % each month's sales represents of the total sales.

In your workbook you have three single charts as I said. Each one has only one value e.g. 30%. When you choose to represent this 30% on a PIE chart as a percentage of the whole, the whole IS 30%, hence the pie chart a) has only one value to work with, and b) by definition this single value of 30% is 100% of the total 30%

With the bars you are giving them an x axis from 0-100 to work with and hence the single series value of say 30% can be shown compared to the 100%.

Were you to put all three series on a single bar chart you would still see each bar stacked one above the other, BUT, and here's the difference, if you were to then change the chart type to a Pie, then you would have three slices. However just because one % was 30% (as in your first chart) you would not expect to see a slice which occupied roughly 1/3 of the whole pie, rather you would see the slice occupying the fraction that 30% bore to the sum of the %s. In the example yuo show these are roughly 30%, 57% & 83% say 170%, hence the 30% slice would occupy only 30/170ths of the whole pie - roughly 17%

As with all these things you need to decide what you are trying to represent and choose the most appropriate chart. Personally I can't see why you can't put all three values on a single chart.

Hi,

As I said, it depends what you are trying to show.

See attached where I have added the single chart with bars and the pie chart.
However whether the pie slices are what you want to convey only you can say.

Hi,

What do you expect to see given the 3 current percentages of 30, 56 & 83

perhaps something like this where the 2 projects build up each half of the pie.

to get slices to change colour you need to have 3 slices each with a unique colour and formula to either show or hide the slice.

Not sure I understand the bit about borders and single slice pie. Surely a single slice pie IS the pie?

But it is not 1 set of data. It's 2 sets with the 3rd set being what is remaining of the previous 2.
You can remove the border but then I don't think the chart is clear or easy to understand.

Picking up on Andy's example is this what you mean.

But as Andy says it doesn't convey the idea of it being a slice of a pie.