cancel
Showing results for 
Search instead for 
Did you mean: 

Limit on number of series in bubble charts?

Former Member
0 Kudos

Hello all,

I need to use a bubble chart in one of my visualizations (Xcelsius Engage 2008, Excel model only - no live connection), showing gross sales and margin for 13 categories series. If I map the series(es) individually, then they all show on the legend, and the graph limits change as I use the list box selector to choose the particular customer, but no bubbles - or any indication of data points - show up on the graph.

If, however, I choose to map to a range, I do see data points - but only for the first 6 of the 13 categories. I've checked the cell range to ensure all 13 categories are included in the selection, and they are, but - again - only 6 show up, or get mapped to the "series" box.

I've resized to cover more real estate, thinking perhaps Xcelsius just didn't want to display bubbles on a smallish graph field, but with no change in the display results. I have a tree map linked to the exact same data, in the same location, and it works just fine. But nobody likes the tree map; they want bubbles.

Am I missing something, or is there a limit on the number of series a bubble chart is capable of displaying?

Edited by: Jennifer Leppert on Aug 15, 2008 12:34 PM

Two swfs showing the difference and the xlf are located at http://www.mediafire.com/?sharekey=9e4101c4b4a3cdc1d2db6fb9a8902bda. Check under the "AEL" tab.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Jennifer,

The layout of the data is important when binding data to some charts. For the Bubble Chart, when you bind "By Range", the data needs to be in 2-3 rows when using "Data in Rows" or 2-3 columns when using "Data in Columns". Although you can see the series names when using 2-3 rows of data and the "Data in Columns" option, you'll notice that the data is not correct (all the values are dollars, without any percentages).

If you want individualized series names, you will have to manually enter each series, using the "By Series" interface.

Javier Jimenez

PG SDO QA

Xcelsius 2008

Former Member
0 Kudos

Jennifer,

I'm also going to log some problem reports and enhancement requests against these chart types.

However, given our current workload, these will not be considered priorities and will take time to address.

For now, the manual series entry will be the recommended solution.

Good Luck,

Javier

Former Member
0 Kudos

Thank you for the response, Javier. Unfortunately, it doesn't quite answer the problem.

I have tried mapping the series individually. While the interface will capture all of the label data, the graph itself does not show any data points when switching to preview mode, or exporting to another file type. (See "Manual Series.swf" at the link in my initial post for a visual).

The X and Y axes are correct, and do adjust depending on the customer selected in the list box, but, again, no bubbles show up. Is there something else I'm missing, or not doing correctly? I have an evaluation copy - perhaps it is a limit in the eval copy that would disappear upon registration of a full license?

Former Member
0 Kudos

Jennifer, you need a third data value (size). Currently your model only has X and Y values for each series.

Let us know if you have any other questions.

Javier

Former Member
0 Kudos

Well, that explains it - sheer oversight on my part. I had thought the bubble size wuld generate dynamically, as the block did on the tree map. It looks like I will need to write the formula myself, and then link the series size to the formula in the chart.

Thanks so much for the follow up. I appreciate your taking the time to help!

Former Member
0 Kudos

You're welcome. Sounds like you have it right.

Glad to be of service!

Answers (1)

Answers (1)

Former Member
0 Kudos

Good Evening...

I was upgrading my Exclesius 4.5 Model to the 2008 Excelsius model . In the past I had 256 bubbles on a chart...However...this time when I load my model...I can only seem to get about 14 bubbles to appear...Is there something that I'm missing...?

Please let me know if there are any options that I need to change....

Ps...I upgraded to use the Excelsius with Crystal Reports...the next step is to populate data tables wtih flash vars.

Thanks for any help or advice you might have...