bubble charts

  1. D

    Bubble Chart legend

    Ok I think this is simple. I created a bubble chart with info below. How do i get column A to be my legend? <tbody> <colgroup><col><col><col><col><col></colgroup><tbody> Risk Probablity - 1 (low) to 5 (high) Impact - 1 (low) to 5 (high) Traffic Light Risk management strategy Lack of...
  2. B

    VBA Select Case Within Data Series Loop (Colour Each data point in multi-series Bubble Chart)

    Hi. I have a multi-series Bubble Chart (each data point is part of its own data series eg. ActiveChart.FullSeriesCollection(1).Select is first bubble, ActiveChart.FullSeriesCollection(2).Select is second bubble etc.) I want to use a SELECT CASE statement so that a data point is coloured based...
  3. P

    Bubble charts and colours

    Hi Everybody I hope you can help me - I have been searching for the answer and got so far but cant seem to get over the final hurdle I have worked out how to create a bubble chart and pieced together a macro from others work, with the aim of making the bubbles coloured based on a column of...
  4. B

    How to create Bubble Charts from Pivot Tables - Excel does not allow

    Hi, Is there a way to create a bubble chart from a pivot table? The rows include names of opportunities, and I want to include the bubbles to represent Profit size of these opportunities (large profit size = large bubble) along a time horizon (horizons 1, 2 and 3). The Y axis would represent...
  5. M

    Bubble Charts Help PLEASE

    I have created a bubble chart with three different inputs. Country Name, Ease of Doing Business Rank, 2009-2014 Avg. Projected Real GDP Growth and have created a bubble chart from this data. I have created them in a single series and would like to get the country name to appear as a data...

Some videos you may like

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top