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

Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…