How do I create a bubble graph

  • Thread starter Thread starter phocused
  • Start date Start date
P

phocused

I have some data that I am trying to express in a bubble graph. It looks like
this
A1 B1 C1
Team Name : Maturity : Age
xxxx 1 3
vvvvvv 3 1
jjjjjjj 2 6

where Maturity is a value from my maturity model and Age is how long the
team have been running the process in months.

I want to be able to show a chart which looks like this
Horizontal Axis is Time so the age running from 0 thru to 12 months or 1 yr
Vertical axis to be the Maturity which will be 0 thu to 10
and then bubble in the middle which have the name of the team in it or along
side.

i just cannt get it to work.

any one out there that can help?

Rgds Paul
 
What your describing is more like a xy-scatter chart. A bubble chart uses 3
sets of data (x, y, size).

If you really want the appearance of a bubble chart:
Add a 3rd set of data to set sizes, say, 10 for each team. Then, each series
in your bubble chart will have a single x, y, and size value.

Under chart options, Display series labels. Under series format, align to
display in center.
 
Hi Luke M, thankyou for your response. I tried your suggestion but i still
have the same issue. The problem is that the chart refuses to display the
team names or any text for that matter so i cannt see which bubble is related
to which team.

if there is a better method for showing this data then i would be more than
happy to try it, however i would have though this was a simple thing to do.

rgds Paul
 
Back
Top