Skip to Content

Portfolio (Bubble) Chart Capability


I am trying to create a bubble chart using WAD 3.5, the Portfolio chart type seems to be the most appropriate, but I can not figure out how to get the chart to show the metrics per my specification.

X-Axis - Change in Days

Y-Axis - Change in Value

Z-Axis (Size) - Total Value

Bubble Color - Region

Individual Bubble - Opportunity

The results should be a bubble chart with 4 different series, each series containing a datapoint representing an opportunity.

The bubbles are sized based on the total value of the opportunity and are positioned in the chart based on the shift in days (x axis) and value (y axis) from a previous time period.

The data is not a problem, I have a query with all the relevant characteristics and key figures. The issue is getting the chart to properly chart these items. The closest I can get is with:

Row Fields: Region

Column Fields: Opportunity, Key Figure Structure

When I do this, I do get one 'series' for each region, but all the bubbles for each series get placed at the X-Axis value for the first opportunity. Other attempts have resulted in creation of a series for each opportunity.


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Oct 10, 2008 at 01:56 PM

    The frustrating part of this - is that the "Chart Wizard" view in Web App Designer shows exactly this scenario when previewing the Portfolio chart design - a few color-coded series, each containing multiple datapoints, with varying bubble sizes places on the chart based on key figures on the X and Y axes. I can not figure out how to get any query to replicate this.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 29, 2008 at 01:16 AM

    YES ,than's right,this problem is what I confronted.Also ,I found that chart in wad.But could not find the right way to resolve ,Appreciate your answer.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.