Forum Discussion

Copper Contributor

Sep 18, 2020

Solved

Separate bars in stack column chart

I have data like: FY Plan Actual FYTD17 50 75 FYTD18 45 67 Now i want to separate the bars as shown in the attached image. I have made the bar chart but not able to separate i...

Charting

excel

Riny_van_Eekelen
Sep 21, 2020
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.

adi0007.xlsx14 KB

NikolinoDE

Platinum Contributor

Sep 18, 2020

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)