Restore a chart and have a text box updated

[danialier]

Hello,

I have two bar charts minimized, one for hardware revenue and another for supplies revenue. When I restore one of these bar charts I want a text box next to the bar chart to show the revenue for the restored bar chart.

For instance, when I restore the hardware bar chart I want the text box to show the revenue of the hardware, however when I restore the supplies bar chart (and as consequence having the hardware bar chart minimized 'cause I have the automonimize selected), then I want the text box to show the revenue of the supplies.

Is there any way I can do that ?

thks,dani

[MK_QSL]

instead of showing a separate text box, go to presentation tab of each bar chart and use Text in chart.

click on add and under text expression write something like SUM(REVENUE) as per your field name

UPDATE : check enclosed file...

UPDATE : Check updated file showing criteria as per your requirements.

[maxgro]

workaround

- create a grid container (A) with hardware bar chart and hardware text box

- create a grid container (B) with supplies bar chart and supplies text box

- create a single object container and insert containers A and B

[veidlburkhard]

Hi Dani,

I would recommend to create a button to restore the bar chart. This button should simultaneously set a variable, which conditionally shows your textbox.

Regards

Burkhard