How to creat a chart with only text and multiple elements

jmmackey2002

New Member
Joined
Aug 14, 2015
Messages
12
I need to create a bubble chart that will chart products based on their position and maturity, with sized plotting points that reflect the products strength/breeding effort.

Chart layout needs to be as follows:

Legend=Product names (Alta, Advanta, Phoenix, Bayer, AgriThority, Central, PCI, Cerner) These would be represented by bubbles according to their position and maturity.
y axis=Position (weak, tanable, favorable, strong, dominant)
x axis=Maturity (embryonic, growth, mature, aging)

So if Alta=favorable and aging
Advanta=tenable and mature
Phoenix=tenable and mature
Bayer=tenable and growth
AgriThority=weak and growth
Central=dominant and aging
PCI=weak and growth
Cerner=weak and embryonic

I need these products to be plotted at the point where the position and the maturity cross paths. A bubble chart also allows you to make the circles(products) different sizes to reflect another aspect, which in my case the size would represent the products strength/breeding effort. I cannot figure out how to lay this all out so that excel can chart it how i'm needing it.

Is this even possible?
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,215,757
Messages
6,126,693
Members
449,331
Latest member
smckenzie2016

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
Back
Top