SOLVED

Separate bars in stack column chart

%3CLINGO-SUB%20id%3D%22lingo-sub-1683480%22%20slang%3D%22en-US%22%3ESeparate%20bars%20in%20stack%20column%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1683480%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20data%20like%3A%3C%2FP%3E%3CTABLE%20width%3D%22170%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%3EFY%3C%2FTD%3E%3CTD%20width%3D%2253%22%3EPlan%3C%2FTD%3E%3CTD%20width%3D%2253%22%3EActual%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFYTD17%3C%2FTD%3E%3CTD%3E50%3C%2FTD%3E%3CTD%3E75%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFYTD18%3C%2FTD%3E%3CTD%3E45%3C%2FTD%3E%3CTD%3E67%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20i%20want%20to%20separate%20the%20bars%20as%20shown%20in%20the%20attached%20image.%3C%2FP%3E%3CP%3EI%20have%20made%20the%20bar%20chart%20but%20not%20able%20to%20separate%20it.%3C%2FP%3E%3CP%3ELet%20me%20know%20how%20it%20can%20be%20done.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1683480%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1683833%22%20slang%3D%22de-DE%22%3ESubject%3A%20Separate%20bars%20in%20stack%20column%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1683833%22%20slang%3D%22de-DE%22%3EIf%20I%20may%20recommend%2C%20why%20not%20make%20two%20bar%20charts%20with%20the%20respective%20data%3F%20%3CBR%20%2F%3E%20.......%20for%20a%20quick%20solution%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20I%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
New Contributor

I have data like:

FYPlanActual
FYTD175075
FYTD184567

 

Now i want to separate the bars as shown in the attached image.

I have made the bar chart but not able to separate it.

Let me know how it can be done.

 

Thanks!

4 Replies
If I may recommend, why not make two bar charts with the respective data?
....... for a quick solution

I would be happy to know if I could help.

Nikolino
I know I don't know anything (Socrates)

@adi0007 

That's not clear what exactly you'd like to separate. Let take FYTD17. You have Plan (bar from 0 to 50) and Actual (bar from 0 to 75). You would like to show Actual only from 70 to 75. Why from 70, not from 60 or 65?

@Sergei Baklan,

I want to separate Plan and actual.

I have attached an image , i want to do exactly the same.

 

@Nikolino, I wan to make chart same as in the image attached.

Best Response confirmed by adi0007 (New Contributor)
Solution

@adi0007 Perhaps like in the attached file?

 

1. Create a stacked column chart.

2. Change chart typ for the Actual to a Line. 

3. Format the line to have "no line" and change the marker to a "-" and enlarge it to the width of the Plan column.

4. Add data labels and format to your likings.