SAP IBP Excel UI - Planning view, Plotting Multiple Charts on one Sheet

[former_member629626]

We have a requirement in our Client to plot multiple Charts on one Sheet itself, Is there any Standard Template fro SAP on this. I checked the note 1790530 - S&OP / IBP Planning View Templates for the Excel Add-In and i did not find any templates with multiple charts on same sheet.

If this can be done through VBA does anyone has any sample code for the same, if yes please share.

[anna_linden · Accepted solution]

Hello Nikunja,

SAP does deliver samples with multiple charts. Only the ones from the note with one chart. The ones from the note already include VBA code however to build the one chart that you see there. In the end, you can use that as a base and further adapt.

But this is project work to customize it towards your needs. I know examples from customers where this was done and it looks quite appealing. So could be a good investment.

Best regards,
Anna

[ankpatel]

Hi Nikuj,

I would suggest to use the Pivot Table and create multiple charts based on that table. Creating multiple charts using Chart feeder sometimes gets complex.

But if you are still looking for the Charts delivered by SAP, use below link which has multiple charts - https://github.com/SAP-samples/integrated-business-planning-excel-add-in-templates/blob/master/Formu...

Regards

Ankur