Skip to Content
0
Former Member
May 26, 2010 at 08:55 PM

Xcelsius Bubble Chart - Drill Down Issues

36 Views

Hi ,

Product : Xcelsius SP 3

I have a bubble chat with 7 series. The chart is showing up bubbles with different size and colors as per the settings.

The problem is with drill down

I want to drill down to a X-Y chart when I click on bubbles. Each bubble click will drill down data into that X-Y chart as a pop up. I know how to do it as I have done it in the past with other components.

But when I use drill down with bubble chart, I have to assign separate destination area for each series which makes it difficult to drill down into a chart. What i want is the bubbles to drill down data into a single row so that I can map the Y-axis of chart component to that row and X axis as fixed labels. But I am not able to do that. Moreover once inserted there is no way to clear the destination cells.

However if I use data in range options in bubble chart then I can use drill down as I get only one series in that case. But that method also has limitations.

1. I am not able to display series name on the bubbles. It doesn't make any sense to show bubbles without any labels.

2. All bubbles are of same color.

Is it possible to overcome above two limitations when using data in range option?

Please help if someone has encountered this issue. There has to be some solution for this.

Thanks,

Tarun