Forum Discussion
Solved
Excel butterfly Chart
Hi, I want to create a butterfly chart on MS Excel, on the right it will be data regarding revenue and on the left it will be P+L (profit and loss). The issue lies with the P+L on the left, Pro...
tayyeb253 I would create to separate series for Profits and Losses. Both as negatives and each with their own color. Make sure that the series overlap is set to 100%. I also custom formatted the horizontal axis to show only positive numbers.
See example attached.
tayyeb253 I would create to separate series for Profits and Losses. Both as negatives and each with their own color. Make sure that the series overlap is set to 100%. I also custom formatted the horizontal axis to show only positive numbers.
See example attached.
- How to you set the series overlap to 100%?
- Thank you for your help riny_van_Eekelen.
