Bar Graphy with Calculated Percentages

B

briandhowells

I initially posted this in the powerpoint group by mistake, so forgive
me if you've seen it already (I make the charts in Excel and then
transfer to Powerpoint, thus the mistaken posting in that group).

<<So, I've got a bar graph showing each fiscal year's spending and
revenue and at the top I want to show net cost as a percent of total
spending. In other words, in a year where I spent $100 and brought
in
$50 of revenue, the bars would look something like this:

50%
_
| |
| | _
| | | |
| | | |


I've got the bar graph made no problem, just need to get those %
values to show up. Thanks in advance!
 
J

Jon Peltier

What you need is custom labels. Calculate and format the labels in the
worksheet, then use one of these utilities to add them to the chart as data
labels:

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

- Jon
 

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

Top