Actual vs Budget using Clustered Column Chart

%3CLINGO-SUB%20id%3D%22lingo-sub-1923996%22%20slang%3D%22en-US%22%3EActual%20vs%20Budget%20using%20Clustered%20Column%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1923996%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%26nbsp%3B%20I%20have%20a%20new%20challenge%20--%20trying%20to%20find%20the%20best%20way%20to%20showcase%20Act%20vs%20Budget.%26nbsp%3B%20I%20saw%20a%20chart%20online%20which%20looks%20pretty%20good.%26nbsp%3B%20Problem%20is%2C%20I%20cannot%20somehow%20copy%20the%20steps%20although%20it%20seems%20pretty%20simple%20enough.%26nbsp%3B%20I'm%20not%20sure%20what%20I'm%20doing%20wrong%20(I've%20done%20it%20a%20few%20times%20but%20never%20end%20up%20where%20I%20should%20be).%26nbsp%3B%20File%20attached.%26nbsp%3B%20Any%20thoughts%20on%20which%20step%20I'm%20doing%20wrong%2C%20would%20be%20very%20helpful.%26nbsp%3B%20Thank%20you%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1923996%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1924482%22%20slang%3D%22en-US%22%3ERe%3A%20Actual%20vs%20Budget%20using%20Clustered%20Column%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1924482%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F835216%22%20target%3D%22_blank%22%3E%40Maddy1010%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EChange%20type%20on%20Stacked%20Columns%3C%2FP%3E%0A%3CP%3EBudget%20and%20Positive%20Var%20on%20one%20axis%2C%20Actual%20and%20negative%20on%20another%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20468px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F235596i21A766BD3BD76E2E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAfter%20that%20play%20with%20series%20overlaps%20and%20gaps%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20279px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F235597i8C0ADA1EE3381CB0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EDon't%20forget%20to%20place%20data%20in%20proper%20order%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20292px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F235598i97F0FB05EBE6C3E5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThat's%20only%20to%20show%20the%20way%2C%20I%20didn't%20finalize%20the%20chart%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20476px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F235599i3D8D0C621A35B2D4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1924810%22%20slang%3D%22en-US%22%3ERe%3A%20Actual%20vs%20Budget%20using%20Clustered%20Column%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1924810%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F835216%22%20target%3D%22_blank%22%3E%40Maddy1010%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20think%20Sergei%20Baklan%20has%20answered%20your%20question%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi.  I have a new challenge -- trying to find the best way to showcase Act vs Budget.  I saw a chart online which looks pretty good.  Problem is, I cannot somehow copy the steps although it seems pretty simple enough.  I'm not sure what I'm doing wrong (I've done it a few times but never end up where I should be).  File attached.  Any thoughts on which step I'm doing wrong, would be very helpful.  Thank you in advance.

 

@Hans Vogelaar 

2 Replies

@Maddy1010 

Change type on Stacked Columns

Budget and Positive Var on one axis, Actual and negative on another

image.png

After that play with series overlaps and gaps

image.png

Don't forget to place data in proper order

image.png

That's only to show the way, I didn't finalize the chart

image.png

 

@Maddy1010 

I think Sergei Baklan has answered your question