Planning View with "Display header name" shifts header names on top of chart — avoid?

[vincentverheyen]

Let's say there is a Planning View as such, namely one which uses the option "Display header name" (Settings > Formatting > Display header name):

When one now opens the chart by clicking the chart button, then the names of the headers (for example "Attribute 2") appear right on top of the chart, instead of at the bottom of row 5 where they should remain.

How can we keep these headers aligned towards the bottom of row 5 permanently as such (instead of requiring the end user to manually hit Refresh in the IBP Excel Add-In Ribbon):

Perhaps possible with Visual Basic / Macros (or is there an easier/better way), what would be the exact steps to achieve this please?

[KatarinaDajic]

Hi, random question, how to change the color in that area where you have green? Thanks!

[mohnotrahul]

Hi Vincent,

Please do the following :

1. goto Developer-> Visual Basic > Modules (for the VBAProject of your planning view)

2. In "Wrapper" module, you will find subroutine as below:

Sub Refresh()

Application.Run ("SAP_IBP_Chart.xlam!Refresh")

End Sub

3. Modify it by adding additional line as below:

Sub Refresh()

Application.Run ("SAP_IBP_Chart.xlam!Refresh")

Call AFTER_REFRESH

End Sub

This will avoid user to refresh again as you are calling the refresh along with chart refresh.

Thanks

Rahul Mohnot

[vincentverheyen]

Hi mohnotrahul. Brilliant, this is very clear. I tried all the mentioned, however in my testing it didn't work as expected. I still had to press the Refresh button in the Add-In's Ribbon?