want to prepare chart with 2 values
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
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
Last edited by teylyn; 08-03-2010 at 11:21 PM.
No secondary axis allowed with 3d variation of charts.
You will need to use the 2d styles.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks