View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Del Cotter Del Cotter is offline
external usenet poster
 
Posts: 560
Default Bubble Chart with text as description of an axis

On Tue, 15 Apr 2008, in microsoft.public.excel.charting,
schleimer said:
I want to create some kind of portfolio chart for purchasing.
The x-axis shall show the supply risk.
The bubble size will be defined by the purchasing volume of the product
category.


Is this like a BCG, or "Boston Consulting Group" chart? Have you seen Ed
Ferrero's implementation? It may give you some ideas.

http://www.edferrero.com/ExcelCharts...2/Default.aspx

(However, Ed's Excel chart site seems to be down at the present time)

How do I use the text "high risk", "low risk", "high costs" and "low costs"
as description of the axis. At the moment it automatically creates me figures
there.


Create a bubble range with invisible bubbles, placed where you want the
text to be, then customise the labels to read the text required. Use
this as an example:

http://www.branta.demon.co.uk/excel/...spotmatrix.xls

Here, I used labelled invisible bubbles to create the "axis labels" KPC
1, Company A etc.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.