Mirror Bar Chart

Hi,

 

Could you please help me make a mirror bar chart? I multiplied the blue colored series by -1 to make a mirror effect, but I have either a negative sign or brackets in the chart. In addition, I could not align these series at the same level. Thank you!

 

Warm regards,

Murat

 

 

 

 

muratakkas_0-1637953445958.png

 

 

muratakkas_1-1637953739032.png

 

 

 

 

Best Answer

  • @muratakkas 

    Good call out. Not sure there's a perfect answer since Anaplan doesn't have a native mirror chart. here are some ideas. Assuming this is what you want:

    JaredDolich_3-1637973335553.png

    1. One thing you can try is to remove the value on the chart and instead create a separate line item for charting and one for reporting. So your mirror will work and when you hover over the bar, you'll see the reporting value which for the negative chart values will be the opposite. 
    2. The other way, more complicated of course, is to use an index as the x-axis. So for Blue it uses a formula that calculates is left of center (which will be positive, not negative) and for purple it calculates right of center.
    3. Export to Excel, Power BI, or Tableau. There's a free Excel Addon (v4) for Anaplan that will grab your data directly and make your mirror chart. https://www.excel-board.com/how-to-create-a-mirror-bar-chart-in-excel/ 
    4. Last way you might consider is abandoning the mirror chart and go with a plain old bar chart (POBC)

    JaredDolich_2-1637973259031.png

    Honestly don't know how you can line up the bars without some type of trickery like using a 2nd Y-Axis. but I didn't get far with that. Even tried a column mirror instead of bar mirror.

    JaredDolich_1-1637973012853.png

     

     

    Also 

     

Answers

  • Thank you very much! @JaredDolich 

     

    For now I will implement your fourth solution, then I will try to implement the more complex ones  🤔

     

    Warm regards,

    Murat