 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General PowerPoint Questions / March 2008How do I complete the datasheet for a bubble chart in Powerpoint?
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  SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info >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? 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? 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 [quoted text clipped - 7 lines] > > understand how the datasheet works. Could someone please explain the > > different columns? 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? SignatureEcho [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, > [quoted text clipped - 17 lines] >> > understand how the datasheet works. Could someone please explain the >> > different columns? 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 [quoted text clipped - 23 lines] > >> > understand how the datasheet works. Could someone please explain the > >> > different columns? > 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. 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?? > [quoted text clipped - 25 lines] > > >> > understand how the datasheet works. Could someone please explain the > > >> > different columns? ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ 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. SignatureEcho [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 [quoted text clipped - 36 lines] >> >> > the >> >> > different columns? > 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. 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, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ >> 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 [quoted text clipped - 11 lines] > 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. SignatureEcho [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 > >> 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 [quoted text clipped - 13 lines] > > No, it doesn't. Or, it doesn't have to. Depends on how you set up your data. 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 ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.