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

Accepted answers

JaredDolich

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

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.
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.
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/
Last way you might consider is abandoning the mirror chart and go with a plain old bar chart (POBC)

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.

Also

All comments

JaredDolich

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

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.
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.
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/
Last way you might consider is abandoning the mirror chart and go with a plain old bar chart (POBC)

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.

Also

muratakkas

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

Quick Links

Can you help?

Unanswered questions

Anaplan Report page issue in the UX
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
Solution for when 2 time dimensions needed
As shown in the screenshot, each monthly amount (Jan, Feb, Mar 2024) needs to be paid down in the future months (Jan–Aug 2025). The paydown must satisfy certain conditions specific to each month between Jan and Aug 2025. If the conditions are met, the paydown can occur. For example, if $20 is available to pay in Jan 2025…
How to get live small project for learning more.
I have completed level 2 certificate still I am not confident. I want practice more, where I get small project for practice.