• 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.

Excel Stacked Bar

E

edved81

New Member
Hi!
Can you help me making two excel stacked bar charts? To compare the tasks planned and the real.

In chart 1 I need to have just two bars, one with plan coloc and plan new on top of another, and other bar with real coloc and real new.

In chart 2 I need to have just two bars, one with plan coloc and plan new on top of another, and other bar with values of real total.

thank you!


Post moved by mod

/.
 

Attachments

  • Stacked Bar charts.xlsx
    18 KB · Views: 7
Last edited by a moderator:
Format a cluster column chart to have the "New" bars on a secondary axis. FYI: You will need to format the secondary axis to match the primary axis but you can edit the font down so it isn't visible. Their is a large disparity in your data quantity (the big numbers over shadow the small number) so you might consider a different approach. New as a percent of Plan for example. See attached example with your data.
 

Attachments

  • Stacked Bar charts.xlsx
    29.2 KB · Views: 14
You must log in or register to reply here.
Back
Top