Symptom
After creating a chart in Analysis for Office and moving it using the Excel's option (e.g. via context menu), the user is experiencing an issue with the chart.
Some of the issues are:
- The data in chart is not refreshing according to the new variable values or other filters provided;
- The chart is not being adjusted (e.g. range, size) according to the new variable values or other filters provided, but remains static instead;
- Exception in Analysis for Office;
Environment
SAP BusinessObjects Analysis, edition for Microsoft Office
Reproducing the Issue
- Insert a chart in Analysis for Office workbook using its own functionality (i.e. "Analysis" ribbon > "Insert" group > Chart);
- Move the chart using the Excel's functionality (i.e. Option "Move Chart" in chart's context menu);
Cause
When moving an Analysis chart to a new worksheet via the Excel's context menu on the chart, Analysis Office will lose the connection to the chart in the next refresh.
Resolution
In order to move charts created by Analysis Office, it is necessary to use its own functionality:
- Make sure there is an available worksheet to move the chart;
- Open the Design Panel;
- Click on the Components tab;
- Open the context menu in the chart;
- Click on "Move To" and select a new worksheet like shown below:
See Also
Chapter "To insert a dynamic chart" in User Guide of Analysis for Office available in http://help.sap.com/boao (click here to access the online documentation)
Keywords
chart, charts, moving, range, size, move to, losing, lose, loses, connected, sending, sheet, worksheet , KBA , BI-RA-AO-XLA , Excel Addin , How To