flexibel max gauge setting/trellis. Sample included

[amien]

see example .. all looks perfect .. problem is that each country has its own target. so the max on the gauge is of each country different .. i cant get the needed value of each chart in the trellis.. is this even possible?

[sathishkumar_go]

Hi Amien

Check this application. i think u expect this? if not tell clearly

Regards

Sathish

[amien]

No...

i have a trellis with a gauge/tube for every country .. each country has its own target.. But in the max setting of the gauge/tube i can only use the sum of all targets ..this is not what i want. max value should be different for each country. gauge/tube of SE for example should be completly full. at this moment it is not, because i use SUM(value) as expression in max setting of the gauge

Hope its clear now

[#4 · Accepted solution]

Since a Trellis chart uses the same scale for all parts, I am not sure this is the way to go. Perhaps you need to do this the olf-fashioned way and create a gauge per country ...

[amien]

yes .. but then i have to export a sheet .. instead of an object. . whats a good way to get them all the same size and put them all on the right spot?

[#6]

Use the x-pos, y-pos, width and height settings on the Caption tab.

That way you can put each of them exactly on the right spot and make them each the exact same size.