creating a percentage bar chart in excel

[pelican]

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

 

[Jon Peltier]

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