Percentage chart

[Guest]

Hi all! I am trying to create a percentage chart. For example, if the total is 76, but I have 36 of something, the height of column bar should be 76 and 36 of it is some other color, and at the top of bar should display the percentage of 36/76. How do you do it? thanks!!! And is it possible to have two bars within the same x-axis value, and both are the percentage bars? thanks!!

 

[Tushar Mehta]

Plot both 36 and 76 as values in a clustered column chart. Specify an
overlap of 100% (after creating the chart, double-click any of the
plotted series in the chart, then select the Options tab).

Put the value of 36/76 in a cell. Get Rob Bovey's free and misnamed
add-in, XY Chartlabeler, from www.appspro.com. Use it to label the 76
series with the calculated value. Or if this is a one-off process, see
the Excel | Tutorials | 'Data Labels' page of my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Guest]

THANKS SO MUCH!

 

[Guest]

Hi I want to create four series but I don't want them all to overlap, I only want two overlaps which end up in two bars. Is it possible? thanks!

 

[Jon Peltier]

Anthony -

Want them to stack? You can make a clustered stacked column chart
through clever arrangement of your data in the worksheet. See the
details at Stephen Bullen's site:
http://www.bmsltd.co.uk/Excel/SBXLPage.asp#Charting
and look at the description for FunChart4

or at Bernard Liengme's site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

- Jon

 

[Guest]

Thanks

I ran into a little problem that I can't format the y axis, I want to scale it and everytime I try to change the major unit, it just stays the same.

 

[Jon Peltier]

Anthony -

When you change the unit, do you keep the Auto checkbox unchecked?

- Jon