percentage line chart that shows actual numbers as labels

Hi anne - welcome to the board!

there's a great addin for improving excel's chart label options:

http://www.appspro.com

...look for the chart labeler...post back if you need more.
paddy

Hi,

As well as Paddy's suggestion (I'm using XP so I can't test it )

You could add a third column to your data.
This would contain the actual value of the percentage i.e. 34, 131 etc
Add this series to your chart.

Right click>Format Data Series on the line plotting the actual values
Goto>Axis change to Secondary
OK

Right Click>Format Axis on the lables (now on the Right of the graph)

If your Percentage scale is 0 Minimum 1 Maxiumum
Choose 0 as minimum 137 as Maximum on the scale.

Adjust to fit i.e if your % is 0 and 1.2 change data to 0 and 165

This will mirror your Percentages, you can now add lables to your plot line from this data.

Hope this helps

PaddyD and Ian Mac: Thanks very much for your help. I've been away from my desk all day, so I'll try both suggestions on Monday. It's nice to know that there are still people out there who'll give someone else a hand. Many thanks to you both. v/r agk

Appspro- Chart Label Different Format for Series

Just wanted to say a big "Thank you," for posting the information about the AppsPro Utility. I had been trying to do exactly the same thing, i.e. show a series with one format of data (currency) and also show what percentage that series represented. The AppsPro utility makes it a snap!

Gordon