Excel charting

  • Thread starter Thread starter learntoexcel
  • Start date Start date
L

learntoexcel

Hello experts,

I am new to the group and wonder if you can help me with this problem.

Here is a sample of data I want to plot chart with.

A B C (Y axis)
Series 1 12 4 33%
Series 2 5 2 40%
Series 3 10 1 10%

Series 1,2,3 will be my X axis and they are categories. As you can
see, column C is the percentage of B over A. In the chart, I want to
show Column A and B, but I want to label B as percentages instead of
numbers. Is there anyway to do that? Thanks so much for your
assistance.


learntoexcel
 
Make the chart with the first three columns. Use a third party labeler
to use the percentages as data labels for series B. Two good labeling
utilities are Rob Bovey's Chart Labeler (http://appspro.com) and John
Walkenbach's Chart Tools (http://j-walk.com). Both are free, easy to
install, and easy to use.

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