How do I complete the datasheet for a bubble chart in Powerpoint?

  • Thread starter Thread starter irish1213
  • Start date Start date
I

irish1213

I am trying to create a bubble chart in Powerpoint, but am finding it hard to
understand how the datasheet works. Could someone please explain the
different columns?
 
Hi,

Assuming you are plotting by Columns then
1st column is X Value
2nd column is Series 1 Y Value
3rd column is Series 1 Size
4th column is Series 2 Y Value
5th column is Series 2 Size
........ in pairs for each series

Cheers
Andy
 
Hi John,

Thank you for writing. The information you send me was helpful; however I
am having trouble setting up my datasheet because one of my values is text
and I do not know how to put it in as numeric. Any help would be much
appreciated.

Thank you.
 
What do you mean by one of the values is "text." Is it actually words, or is
it a number that's being read as text? Can you tell us specifically what the
value is?

Which version of PPT are you using?
 
I am using Office 2003. On my chart, each bubble represents an investment.
I have about 40 bubbles. I want the bubbles to be labeled by the investment
name but can not get it work.

Help??

Echo S said:
What do you mean by one of the values is "text." Is it actually words, or is
it a number that's being read as text? Can you tell us specifically what the
value is?

Which version of PPT are you using?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


irish1213 said:
Hi John,

Thank you for writing. The information you send me was helpful; however I
am having trouble setting up my datasheet because one of my values is text
and I do not know how to put it in as numeric. Any help would be much
appreciated.

Thank you.
Click to expand...
Click to expand...
 
I am using Office 2003. On my chart, each bubble represents an investment.
I have about 40 bubbles. I want the bubbles to be labeled by the investment
name but can not get it work.
Click to expand...

You can turn on labeling for the bubbles, let PPT label them with one of the data
values, then manually click each label and edit it to what you want it to say.

That may be the only way ... it's the only way I can figure out.
Help??

Echo S said:
What do you mean by one of the values is "text." Is it actually words, or is
it a number that's being read as text? Can you tell us specifically what the
value is?

Which version of PPT are you using?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


irish1213 said:
Hi John,

Thank you for writing. The information you send me was helpful; however I
am having trouble setting up my datasheet because one of my values is text
and I do not know how to put it in as numeric. Any help would be much
appreciated.

Thank you.

:

Have a look at this, it should help
-- http://office.microsoft.com/en-us/excel/HA011170761033.aspx
Amazing PPT Hints, Tips and Tutorials

http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk


:

I am trying to create a bubble chart in Powerpoint, but am finding it
hard to
understand how the datasheet works. Could someone please explain the
different columns?
Click to expand...
Click to expand...
Click to expand...
 
Look at a default bubble chart. Where it says East, West, etc., you can
enter your labels. If you select East, West, North, etc., and delete them,
you'll see where it says "Bubble 1," "Bubble 2," etc. (They'll be every
other row with the next row "size 1," "size 2," etc.) Then you can
right-click the bubbles and choose Format Data Series and choose Series Name
to label the bubbles.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


irish1213 said:
I am using Office 2003. On my chart, each bubble represents an investment.
I have about 40 bubbles. I want the bubbles to be labeled by the
investment
name but can not get it work.

Help??

Echo S said:
What do you mean by one of the values is "text." Is it actually words, or
is
it a number that's being read as text? Can you tell us specifically what
the
value is?

Which version of PPT are you using?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


irish1213 said:
Hi John,

Thank you for writing. The information you send me was helpful;
however I
am having trouble setting up my datasheet because one of my values is
text
and I do not know how to put it in as numeric. Any help would be much
appreciated.

Thank you.

:

Have a look at this, it should help
-- http://office.microsoft.com/en-us/excel/HA011170761033.aspx
Amazing PPT Hints, Tips and Tutorials

http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk


:

I am trying to create a bubble chart in Powerpoint, but am finding
it
hard to
understand how the datasheet works. Could someone please explain
the
different columns?
Click to expand...
Click to expand...
Click to expand...
 
Look at a default bubble chart. Where it says East, West, etc., you can
enter your labels. If you select East, West, North, etc., and delete them,
you'll see where it says "Bubble 1," "Bubble 2," etc. (They'll be every
other row with the next row "size 1," "size 2," etc.) Then you can
right-click the bubbles and choose Format Data Series and choose Series Name
to label the bubbles.
Click to expand...

Sweet ...

That gives each bubble the same label, which may or may not be what irish's
after. If so, great, we're back to my "manually change each one" suggestion.

Hope yours is what works best. <g>
 
Steve Rindsberg said:
Sweet ...

That gives each bubble the same label, which may or may not be what
irish's
after. If so, great, we're back to my "manually change each one"
suggestion.
Click to expand...

No, it doesn't. Or, it doesn't have to. Depends on how you set up your data.
 
No, it doesn't. Or, it doesn't have to. Depends on how you set up your data.
Click to expand...

Shoot me an example when/if you get a chance ... I'd be interested to see how
this works.

Might make a nice page for Yourself'sVoice
 
Back
Top