IBP ChartVBA_Embedded.xlsm multiple members in column axis hidden by chart

[peter_casper]

Dear community,

we came across an issue that only the last member of the column axis will be displayed in the planning view in case someone assigns multiple members.

Example (Layout > column axis members)

1. Period
2. Key figure

In this case only the key figure will be shown mulptiple times on the column axis dependent on the number of selected periods.

We recognized that the other member gets hidden behind the embedded chart for SAP template ChartVBA_Embedded.xlsm.

This looks like a conceptual design gap for me. Does anyone have the same issue and potentially a workaround for that problem?

Best regards, Peter

[former_member813137 · Accepted solution]

Hi Peter,

I believe the row with the periods is there but it's hidden under the chart. Have you tried moving the report down?

Template Admin > Report Editor > move it down so instead of K6 the data starts in K7.

Hope this helps! 🙂

[peter_casper · Accepted solution]

Hi Natalia,

splendid tip. This actually helps to overcome the hidden 4th row in case of using the embedded Excel chart version.

I hope this helps others as well facing this question.

Cheers Peter

[former_member194529]

Hi Peter,

I am wondering if you already found a solution for this behavior? If yes, please feel free to share it here.

If not, I am not totally sure that I understood the full thing about it. You could give it a try with the up to date .XLSM sample file which was last updated on July 13th:

https://github.com/SAP-samples/integrated-business-planning-excel-add-in-templates/tree/master/VBA_T...

Luckily, this could have been addressed on the recent version.

If not, would you mind sharing some screenshots about the behavior as well for better understanding?

Best,

Ivan

[peter_casper]

Hi Ivan,

so far we solved it by using a non chart based template which actually works properly in this regards. We did not try to use one of the latest templates due to the fact that we are not in shape to upgrade all our IBP add-ons to version 2005 at the moment.

Please find below 2 screenshots to illustrate the described behaviour in case of using the chart based VBA template with KF at column level.

Layout: Time horizon and Key figure in column axis
Chart: visible

Chart: hidden and row 4 manually enlarged

best regards, Peter