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

[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?

 

[Andy Pope]

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

 

[John Wilson]

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

 

[irish1213]

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.

 

[Echo S]

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?

 

[irish1213]

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??

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

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.

 

[Echo S]

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

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??

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

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?

 

[Echo S]

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.

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