Values vs. percentages

Hi, eveyone, I know this should be an easy thing to do, but my brain can't seem to get there today. Also, I have a great deal of trouble with the difference between X and Y axes, so I may not explain my problem very well; please forgive me.

I created a stacked bar chart. Each bar represents our average daily census for a particular year, and each of the divisions on the bar represents the number of patients in a particular category. The numbers are marked on the scaling gridlines along the bottom of the chart, (the chart wizard is telling me that this is the "Y" axis, although from what I remember from high school algebra this would actually be the "X" axis - hence my confusion) and are also used as data labels on each division of each bar, or year, on the chart.

What I would really like is for the data labels to read as a percentage of the average daily census (or a percentage of the whole), since the value is already represented on the scaling grid, but I can't seem to figure it out. I can do it in a pie chart, but then I would have to create a different pie chart for every year, which is not what I really want to do.

Any help would be greatly appreciated.

Thanks in advance

OnTheCouch

Hi,

I've got the exact same problem. Whatever I try the 'Show percent' options remains grey in the 'Data Labels'-tab.

What you guys might be looking for is Rob Bovey's XY chart labeler add-in. www.appspro.com

Hi, thanks for your reply but the XY chart labeler didn't do the job.