SOLVED

Excel butterfly Chart

New Contributor

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, Profit is normally indicated using positive values, and Losses are negative.

How would I bring the profit values (product B and D) to the left?

Would it be possible to colour coordinate the P+L, meaning Profit in green and Losses in red (both on the left of the revenue)?

 

 

tayyeb253_0-1658750656966.png

 

4 Replies
best response confirmed by tayyeb253 (New Contributor)
Solution

@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.

Riny_van_Eekelen_0-1658752145581.png

 

 

Thank you for your help riny_van_Eekelen.
How to you set the series overlap to 100%?

@tayyeb253 Select any of the bars in the chart. Right-click. Format Data Series..., Series Overlap.

Riny_van_Eekelen_0-1658753515495.png