putting two data values in a chart

[alvarito]

I am able to create a chart (graph) from data in a spreadsheet and do a show values making it display the value at each point on the graph. But, what I can't do, or don't know how to do, is to add a second value at each individual point. For example. If point one on the graph has a value of 20 and it displays 20 on that point but that point is also 30% of the total capacity, I would also like to add above the 20, or somewhere, the 30% so I can see both values when I look at the graph. Is there a way to do this? Thanks for the help.

 

[PaddyD]

why not simply create a second data series that calculates the percantage of each element in the orignal series, then plot the % series on a secondary axis?

Paddy

 

[alvarito]

I was hoping to show one chart and be able to enter two values

 

[Andrew Poulsom]

This will allow you to add data labels to a chart:

http://j-walk.com/ss/excel/files/charttools.htm