Bubble charts

[csdjj]

Hello, I'm trying to create a chart that I would classify as a cross between
a bubble chart and a regular bar chart.

Specifically, I want to create a chart where:
- The Y-axis data is the # of projects delivered
- The bubble size data is the total revenue for the project

Here's where the weird part comes in, though:
- I want my X-axis data to be labels - not data. In other words, I want
them to say the names of the project types (e.g., Project Type 1, Project
Type 2, etc.)

I've mocked up a view of what I'm looking for but it's not a workable
solution because it's very manual. I'm looking for a way to do it without it
being manual. (I can't seem to include a copy of the mockup here but I can
e-mail it to anyone who wants to see it.)

Any ideas? Thanks!

 

[Andy Pope]

Hi,

One way is to add additional series to use as axis labels.
Each series requires 1 data point. The X & Y Value should position the point
on the x axis.
The size can be set to 1. Format the bubble to have no fill or border.
Apply data label to series using Series Name. Position data label in the
Below alignment.

Cheers
Andy

 

[csdjj]

Thanks, Andy. There are two things that still escape me, though --
1) Using Series Name gives the same name to all of the bubbles. What I'm
looking for is a way for each bubble to have a different name (e.g., Project
Type 1 is the name of the first bubble, Project Type 2 is the name of the
second bubble, etc.)
2) I'm trying to get the labels to show up on the X-axis itself -- not by
the bubbles.

Can that be done?

 

[Andy Pope]

Hi,

Each project requires it's own set of Y and Size values in order for each
data label to display the correct name.
You set the Y value to 0 for each of the points with the X value being 1, 2,
3 etc.
The data labels are then used to mimic the axis labels. You will need to
remove existing axis values.

If you are still stuck you can email me your file.
andy AT andypope DOT info

Cheers
Andy