How to add an 'Action' to a chart?

[Dayna]

Hello All!

I am trying to add an action to a chart, I know this is possible within the Gauge chart, but I would like to do it in a bar chart... What I am trying to achieve is:

When chart is selected/maximised, clear all the date field.

Can you advise please the best way for me to achieve this?

Many thanks!

Kind Regards,
Dayna

[Miguel_Angel_Baeyens · Accepted solution]

Hello Dayna,

Go to Sheet properties (right click on the background of the sheet -> Properties) and Select "Actions" tab. In the lower part of the dialog window, select the chart you want to use, and click on "Add Action..."

Regards!

[Dayna]

Perfect! Many thanks!!!

[#4]

Hello Miguel,

I am having an issue with this action.

My goal is to show a text object when a particular chart is selected. Consider the text object as a legend to the chart.

I have created via the sheet propreties an action on my chart as follow: Restore Object 'TX11' (TX11 being the text object).

The problem i am having now is the text object is showing but immediately minimizes. I tried every option in the Caption tab from the text object by selecting auto minimize, just minimize, then just maximize but nothing that will restore the text object when the chart is selected and auto minimize when the chart is minimized.

Do you know when i am doing wrong?

Sebastien.

[Miguel_Angel_Baeyens]

Hi Sebastien,

What event are you using to trigger that action in the chart? Sheet properties only allow you to create triggers when the sheet is activated (you click on it) or when you leave it (you click on any other sheet tab in the document).

Regards.

Miguel

[#6]

Miguel,

I use the event 'restore' the text object when chart CHxx is selected. I do this in the following menu

Sheet Properties/Triggers/Sheet Object Event Trigger and I select the object in which I want to add an action.

Regards,

Sebastien.

[Miguel_Angel_Baeyens]

Hi Sebastien,

Sorry, I'm using version 11 SR2 and that option is not available in the sheet properties, therefore my question. In version 10 you need to allow the text object to be minimized, in the text object properties, Caption tab. So when the chart is activated, the TX01 object is restored, and when deactivated, minimized (in my case). That should be all, and that works in my computer.

Hope that helps.

Miguel

[#8]

Hi Miguel,

The action restore wasn't put in, only minimize.

It works now.

Thanks.

Sebastien.