Comparing two pie charts

[georgina_spary]

I would like to display two pie charts next to each other (Programme 1 vs Benchmark). The trouble is that Benchmark has more dimensions than Programme 1 so the automatically assigned colours are different for the same dimension, between the two pie charts. This makes the comparison very hard to read.

It's an automated report covering 80 Programmes against 24 Benchmarks, so I can't hard code a colour against each dimension. I want to build one chart which consists of two pie circles. If I put both expressions in 1 chart I get a mess of inner/outer rings, again very hard to read, I just want two charts next to each other.

Any ideas anyone? I've never used Trellis before, would that be the way to go? if so where do I find that?

Thanks in advance

George

[#2 · Accepted solution]

Hi georgina_spary,

Assuming you have the following kind of data:

Program:

load * inline

[

ProgramName, SomeValue

Monday Sports, 100

Tuesday Rest, 300

Wednesday Work, 10

];

Benchmark:

load * inline

[

ProgramName, AnotherValue

Monday Sports, 1000

Wednesday Work, 100

];

You could create two pie charts with dimension ProgramName. One pie chart can have Expression of avg(SomeValue). Clone the pie chart and change the Expression to avg(AnotherValue).

Right click one pie chart -- Properties -- Colors tab -- click Persistent Colors -- OK. Repeat the process for the next pie chart. The result will look like this and might be easier to read.

HTH

[georgina_spary]

That's just what I need, thanks, I'll give it a go.