IBP Excel Template- Not able to view more than 12 time buckets in Chart

[Former Member]

Hi Experts,

I am using SAP provided excel template to view my S&OP data in IBP Excel 5.0. The issue is that I am not able to increase the time bucket to 30 months from existing 12 months (provided as standard setting) i.e. the bar chart is showing data for 12 months only.

I have modified the following settings in Chart-Feeder :-

1) Modified the 'Time Headers Range) to 29 (i.e. No. of Time Periods - 1)

2) Extended the Chart Data to include 30 time buckets. Now the Chart-Feeder is depicting data from Mar'15 - Aug'17.

However after refreshing the Planning View, the chart is still showing data for 12 time buckets only i.e. the changes done in Chart-feeder are not reflecting in the Bar Chart.  Am I missing some additional setting?

Thanks,

Diwakar

[Alecsandra · Accepted solution]

Hi Diwakar,

You also need to right click on the chart -> Select Data and extend the chart's data range.

Regards

Alecsandra

[Former Member · Accepted solution]

Thanks Alecsandra.

The issue is resolved now.

Regards,

Diwakar