creating a percentage bar chart in excel
 

Hi all

I would greatly appreciate if some one could help me with this.

I have number of variables with values, which i need to compare each
other using bar charts and percentages, when i develop the bar chart,
there is no option as to depict my variables as percentage of the total
values
For eg: if i have test which is positive in 20 males and 30 females of
the total population of 100... how can i compare it as a percentage in
a bar chart alongside from my excel data

I can send a small sample of my data if anyone can help me on that

Thanks
Arun

creating a percentage bar chart in excel
 

You have a worksheet with extra rows and columns. Put formulas in blank
regions that calculate the desired percentages, then plot the calculated
values.

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


"pelican" wrote in message
ups.com...
Hi all

I would greatly appreciate if some one could help me with this.

I have number of variables with values, which i need to compare each
other using bar charts and percentages, when i develop the bar chart,
there is no option as to depict my variables as percentage of the total
values
For eg: if i have test which is positive in 20 males and 30 females of
the total population of 100... how can i compare it as a percentage in
a bar chart alongside from my excel data

I can send a small sample of my data if anyone can help me on that

Thanks
Arun