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!

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"csdjj" <(E-Mail Removed)> wrote in message
news:99F7C49A-C09D-47BD-9C9C-(E-Mail Removed)...
> 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!
>
>
>
>

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" wrote:

> 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
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
> "csdjj" <(E-Mail Removed)> wrote in message
> news:99F7C49A-C09D-47BD-9C9C-(E-Mail Removed)...
> > 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!
> >
> >
> >
> >
>
>

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"csdjj" <(E-Mail Removed)> wrote in message
news:32AEA933-B052-457E-84E6-(E-Mail Removed)...
> 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" wrote:
>
>> 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
>>
>> --
>>
>> Andy Pope, Microsoft MVP - Excel
>> http://www.andypope.info
>> "csdjj" <(E-Mail Removed)> wrote in message
>> news:99F7C49A-C09D-47BD-9C9C-(E-Mail Removed)...
>> > 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!
>> >
>> >
>> >
>> >
>>
>>