ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   bubble chart (https://www.excelbanter.com/charts-charting-excel/48487-bubble-chart.html)

RHI

bubble chart
 
Hi Folks,
I am trying to use the Bubble chart feature and I am facing a strange
behaviour.
I have 3 columns - Risk , Value and Score
If I link the values from a diff spread sheet, my axis scale varies when
the last row is selected. If I have static values unders these columns, I do
not face the issue. BTW, the value itself is the same whether it is linked or
not. What am i missing?

Here is the data I am trying to use in the bubble chart:

Risk Benefit Score
2.3 4.2 1.9
3.2 3.2 0.1
1.3 3.8 2.5
2.9 2.5 -0.4
0 2 2
2.6 4.6 2
2.7 2.5 -0.2
3.4 0 -3.4
1.7 2.9 1.2
5 5 0.1




All times are GMT +1. The time now is 09:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com