• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Bar in Bar graph...

Vignesh Veerasamy

Vignesh Veerasamy

Member
Dear Gurus,

Got a requriement for user for his yearly presentation.I suggested to go to stacked bar graph but he needs the split up similar in attachment.

Thanks in advance.
 

Attachments

  • Book1.xlsx
    10.3 KB · Views: 6
Vignesh Veerasamy said:
Dear Narayan Sir,

Thanks.
You are awesome.
Can know how it is done.?
Click to expand...
@ vignesh,
1. Select data including header.
2. Insert clustered column chart.
3. Select chart goto ribbon=>design=>switch row column.
4. Right click on first column on chart (or any columns other than total).***
5. Click format data series.
6. Click series option.
7. Click secondary axis.
8. Repeat point (4,5,6,7) for all columns on chart except total column.
***. If you face problem in right clicking than select any column and then navigate with arrow keys and then use keyboard right click.
9. Right click on total column on chart.***
10. Click format data series.
11. Click series option.
12. Reduce gap width to adjust total column width with rest of all columns(it is 50% in my workbook).
13. select total column => goto ribbon => layout => datalabel => outside end
14. select rest column => goto ribbon => layout => datalabel => inside end
15. See it twice, you done it what narayank991 did above.


PS: If count will not increase too much in total than you should scale you axis equally.
PFA where axis scales are equaled.

Regards,
 

Attachments

  • Book1- sol2.xlsx
    11.4 KB · Views: 5
Bhawani said:
@ vignesh,
1. Select data including header.
2. Insert clustered column chart.
3. Select chart goto ribbon=>design=>switch row column.
4. Right click on first column on chart (or any columns other than total).***
5. Click format data series.
6. Click series option.
7. Click secondary axis.
8. Repeat point (4,5,6,7) for all columns on chart except total column.
***. If you face problem in right clicking than select any column and then navigate with arrow keys and then use keyboard right click.
9. Right click on total column on chart.***
10. Click format data series.
11. Click series option.
12. Reduce gap width to adjust total column width with rest of all columns(it is 50% in my workbook).
13. select total column => goto ribbon => layout => datalabel => outside end
14. select rest column => goto ribbon => layout => datalabel => inside end
15. See it twice, you done it what narayank991 did above.


PS: If count will not increase too much in total than you should scale you axis equally.
PFA where axis scales are equaled.

Regards,
Click to expand...
Dear Bhawani,

Thanks for your patient reply.
You are awesome.
 
You must log in or register to reply here.
Back
Top