Solved

Excel Bubble Graphs

Posted on 2012-04-10
2
497 Views
Last Modified: 2012-04-10
Hello,

Need some guidance on bubble graphs within Excel.  I am able to great the graph but having issue with the labels in that it reflects the value and not the name.  I have attached the document with the graph.  I am looking to have the labels column B and not the numeric values.

Thank you

Nick
Financial-Risk-Assessment-Table.xlsx
0
Comment
Question by:nmolliconi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 42

Accepted Solution

by:
dlmille earned 500 total points
ID: 37828968
To label the bubble charts, which are like XY charts, you have to label them manually by clicking on the value label and editing it.

You can, however, use VBA - or better yet, an addin that can help you label your charts, very easily.  Here's a very good chart utility and its also free:

http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers,

Dave
0
 

Author Closing Comment

by:nmolliconi
ID: 37829107
Thank you Dave
0

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

635 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question