Sep 18 2020 05:16 AM
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 it.
Let me know how it can be done.
Thanks!
Sep 18 2020 07:03 AM
Sep 18 2020 12:45 PM
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?
Sep 20 2020 09:12 PM
I want to separate Plan and actual.
I have attached an image , i want to do exactly the same.
@NikolinoDE, I wan to make chart same as in the image attached.
Sep 20 2020 10:08 PM
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.
Sep 20 2020 10:08 PM
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.