Changes to multiple Charts (Something like PasteSpecial in Excel)

[IAMDV]

Dear All,

I have 20 guage charts in my document and I have to make some changes across all the charts. This includes both expession & format changes... I don't want to go through the same changes manually for all 20 charts. Please can someone show me the light?

Cheers - DV

[disqr_rm · Accepted solution]

Hi DV,

For expressions, you could use Expression Overview from Settings Menu. And for format you can make changes to one chart and use Format Painter Tool button (with a brush on the toolbar) to copy the format to other charts. Just click on the source chart you want to copy format from and click this button, and then click on the target chart. This may not give you 100% of copy/paste solution, but may reduce good amount of manual work.

Hope this helps.

Rakesh

[Miguel_Angel_Baeyens]

Hello,

If it's something related to format, use a template in the Layout tab of the chart properties, Theme Maker, and follow the steps to store th attributes you want the other objects to get.

If you want to change something (say a field name) in the expressions, then you can use the Settings menu, Expression Overview, and replace the old field name with the new field name.

Hope that helps.

[IAMDV]

Yeah! This does not do the 100% job. I am storing all my large 3-5 set analysis expressions in the variables. Is this a good practice? Or Is there a better approach to calculate the expressions in the script? Right now I am using variable overiew...

[Miguel_Angel_Baeyens]

Hello,

Although you hardcode an expression in the script (or the variable overview) and you assign it to a variable, it will not be calculated until the variable is called (expanded). I sometimes use this with include files so the exchange of files is only about the variables text file and the user only has to replace this file and reload.

The advantage of doing in the variable overview is that you can change it in runtime without need of reload. The advantage of doing in the script is that you cannot accidentally (specially in the development process) accidentally delete or change one of these variables, and if you do, just reloading will get back to normal.

However, if you are not repeating expressions, my suggestion is that the chart itself is the best place to store them.

Hope this makes sense.

[IAMDV]

Brilliant! very clear explanation. Many many thanks.

[#7]

Don't forget you can use the double-click on Format Painter icon which will hold the settings you are transferring and then you can click on each individual (multiple) objects to format it the same as the original object, rather than clicking on the Format Painter button each time for all the objects.

[IAMDV]

CheenuJanakiRam - Thank you for the tip. This will be handy!

Cheers - DV

[#9]

"single click on format painter and hold ctrl key to apply to multiple objects" is this also possible?