Hello,
I am trying to create a chart in excel that is a 3-D bar graph with an y axis range from 0-2000. There are two sets of values in each bar. Let say there are 250 kittens and 1150 dogs, so the bar chart shows a very small block of blue to represent kittens and a very tall purple block above it to represent the 1150 dogs. I want to be able to show the % of kittens as part of the whole lot of kittens+ dogs on the chart. I don't want the chart to show the value of 250 kittens. I want it to show the total % of kittens rather than the acutal number. When I try to populate the values on each bar it only shows the #, but I can't get it to show the %. How can I get the chart to show the % total instead?
Thank you for your help.
Configuration: Windows XP Internet Explorer 7.0, Excel 2003
Calculate percentage in excel Chart excel macro Dao excel change cell format Excel 2003 macro paste 'format=text' Excel 2007 custom date format Excel 2007 format series alphabet Excel conditional formatting no more than 3 Excel file how to convert the url link into url format Excel vba get formatted value Format date in excel Formato mes escrito en excel Formatting color in excel if Formatting conditions for excel if then How to calculate percentage in excel How to make color coded pie chart excel Increase volume by percentage in excel Macro cut formatted cells only excel Macro to change the date format in excel