Skip to Content
Former Member
Oct 28, 2013 at 10:42 AM

Diagrams/ graphs go back to default layout after workbook refresh


I've created an Analysis for Office workbook which contains one query. This query has 7 keyfigures in the columns and in the rows 6 months are displayed. Based on one table I've created seven line charts which each contain one of the keyfigures and displayes the trend of the 6 months.

This works fine,but when I re-open the workbook and refresh the data, all 7 graphs display all the keyfigures. However I want to have 1 keyfigure per graph. As a solution I do not want to create seven different tables with one keyfigure.

Any tips of tricks? I'm using Analysis for Office in combination with BW7.3