how can i add a category to XY-graph?

G

Guest

I would like to create an XY-graph with 3 data tables :
1. Name of company : category
2. dividend yield : data
3. ratio : data
how can i see 1 next to XY data point (created from 2 and 3). I can make the
XY with 2+3 without any problem, but it makes it impossible to see which
company name goes with it. It would be nice to be able to show this.
thanks for the help.
 
J

Jon Peltier

Bruno -

You can use a third party add-in to apply data labels from a worksheet
range to plotted points. Here are two very good ones which are free,
easy to install, and easy to use:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding data labels to an XY scatterplot 1
xy scatter graph 0
XY scatter plot 3
Macro for graphing 1
XY Chart ontinued line 2
inserting specific points on a graph and label them? 5
scroll/zoom xy chart 4
basic xy scatterplots that should be easy 0

Top