Excel bar charts with percentages
 

I have created a bar chart which shows both total expected and now current
revenues of various projects using two colors within a single bar column.
Now I want to add a third piece of information to show the completion
percentage of the projects. If this is possible how can it be accomplished?

Excel bar charts with percentages
 

Calculate the percentage in your worksheet. Add the data to the chart. Try
copying the data series from the worksheet & Paste Special onto the chart.

Charts aren't for doing calculations; they are for displaying the results
of calculations done elsewhere.
--
David Biddulph

"Barry" wrote in message
...
I have created a bar chart which shows both total expected and now current
revenues of various projects using two colors within a single bar column.
Now I want to add a third piece of information to show the completion
percentage of the projects. If this is possible how can it be
accomplished?

Excel bar charts with percentages
 

Compute the percentage in the worksheet, then add them as data labels to an
existing (or a new hidden) series in the chart.

Andy Pope uses this technique in this example:

http://andypope.info/charts/StackColTotal.htm

Use your percentages as custom labels instead of the totals. You can add
custom labels using one of these free utilities:

Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

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


"Barry" wrote in message
...
I have created a bar chart which shows both total expected and now current
revenues of various projects using two colors within a single bar column.
Now I want to add a third piece of information to show the completion
percentage of the projects. If this is possible how can it be
accomplished?