want to prepare chart with 2 values

**munna316** · 07-29-2010, 06:52 AM

I want to create a chart with 2 values
Eg below:

name marks percentage
Total no. 76 100%
Pass 54 71%
Fail 22 29%
No result 41 54%

I need to create a chart where I want to show both the marks and percentage on Clustered Column 3D chart.

When I try to create the chart I get only the marks bars and the percentage bars are just flat shown on the chart. Pls helt

Thanks for your answer

**teylyn** · 07-29-2010, 07:06 AM

If you want to show absolute numbers and percentages in the same clustered column chart, you need to move one series, either absolute numbers, or percentages to the secondary axis.

Post a workbook with your data and chart and someone here will be able to help.

Edit: see attached for a suggestion of data layout for a combined column chart

cheers