Ullinortel
IS-IT--Management
the pivot table result is changing depending on the field button content
selected, e.g. you've got a button 'Sales Region' the pivot table will
show up the result for region 'North' or 'South' per month. If one inserts a
diagram to visualize the resutls, one need to select the pivot table and build the diagram. But the axis of the diagram won't change, means if
one selected month 1 - 6 for the first diagram (North) it stays stable for
South again, althogh the period here is from 1 - 9. How to get an
automatic adjustment of the diagram according to the contents
generated of the pivot fields?
selected, e.g. you've got a button 'Sales Region' the pivot table will
show up the result for region 'North' or 'South' per month. If one inserts a
diagram to visualize the resutls, one need to select the pivot table and build the diagram. But the axis of the diagram won't change, means if
one selected month 1 - 6 for the first diagram (North) it stays stable for
South again, althogh the period here is from 1 - 9. How to get an
automatic adjustment of the diagram according to the contents
generated of the pivot fields?