Forum Discussion
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...
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 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.