Drilldown 2 Pie-Chart frm a stacked column (not easy)

other Xcelsius - Crystal Dashboard Design
1

Hello Experts,

I have a scenario where I have a stacked column chart and I have to drill down from this chart to a pie-chart. Each stacked column in the original sheet is made up of multiple series. So if I mouse click on any series in one of the columns of the stacked column chart, the drill down to pie-chart should display all the contents from that column. I’m able to get this work partially… From what I created, I’m able to drill down to pie-chart with correct values, if I click on only one of the series in any of the columns in the stacked column chart. However, If I click on any other series in the columns, the drill down to pie-chart is not working.

Please find the attached test.xlf file with the solution I have so far. Here are the steps you need to take to get to the problem:

  1. Preview the .xlf file.
  2. Select a value from the label (A1 or A2 or A3) this would populate the stacked column chart with 4 series (b,c,d,and e) across 4 columns (Q1-current, Q1-Prior, Q2-Quarter and Q2-Prior)
  3. In my current scenario, I have been able to enable the drill down to the pie-chart if I click on series “b” in any of the 4 columns (Q1-current, Q1-Prior, Q2-Quarter and Q2-Prior). If you click on any other series (c,d and e), the drill down to pie-chart does not work.

So I need a solution which would enable me to drill down to the pie-chart when I click anywhere on a particular column (Q1-current, Q1-Prior, Q2-Quarter and Q2-Prior), irrespective of the series (b,c,d and e).

Please let me know if there is any way we can achieve this in Xcelsius.

Thanks a lot! Best Regards.
test.zip (14.0 KB)

duderits (BOB member since 2011-01-05)

2

Welcome to B:bob:B!

I’ve removed the word ‘urgent’ from this topic’s subject as everyone who provides help on here is a volunteer . What is urgent to one person is not so for the other users of this board. Good Luck :wink:

Nick Daniels :uk: (BOB member since 2002-08-15)

3

Hi,

For this you’ll need to use the position insert from the drill down to provide a value for the selected column.

The series destination range has to be different cells, so each series need a separate destination.

Then all you need to do is use match/index to generate the pie chart output.

It wouldve been easier if your stacked chart was a different format, then you could have used the series name rather than the position, as at the moment these are the same values ie b…e.

See attached (this is 2008 3.4).
test_mmc.zip (14.0 KB)

Michael McBennett :uk: (BOB member since 2002-08-19)

4

Michael,

Thanks a lot! This is exactly what I was looking for. I really appreciate your time.

Best Regards.

duderits (BOB member since 2011-01-05)