Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a small issue/requirement with Linear Gauge in the straight table. I want to show the % along with the representation.
Can anyone help me with this?
A screenshot has been attached.
Thank you in advance.
Regards,
Sachin
I would not mess around with overlay charts if not absolutely necessary. In your case, just adding another column like maxgro suggested should give you similar results, but much better maintainable.
A single chart could look like
Hope to be wrong but I don't think it's possible in the same column.
You can add a column.
Hi,
Can I overlap table on top of table. If yes, can you let me know the rgb() value to make the background color for that expression transparent.
Regards,
Sachin
green(0)
argb(0,0,255,0)
the bold parameter is opacity
ARGB(alpha, e1, e2, e3)
An alpha of 0 corresponds to full transparency. An alpha of 255 corresponds to full opacity.
Thank you.
So as per my understanding I need to overlap chart with actual values on top of chart with linear gauge and then make the background for the required expression as white(0).
I would not mess around with overlay charts if not absolutely necessary. In your case, just adding another column like maxgro suggested should give you similar results, but much better maintainable.
A single chart could look like
Hi Aditya,
there is an easy workaround to achieve your favoured result in one straight table. Look this example:
You have to place the numerical column just behind your linear gauge column. Set the header of the numerical column to =' ' , got to the Presentation Tab and mark the alignment of Data(numeric) to Left. Then go to Chart Properties, Style and uncheck the 'Vertical Expression Cell Borders'. After that you got a result similar to the above.
Happy qliking
Burkhard
Hi swuehl ,
How did u do that?
Can you tell, How to achieve this? If you share sample file that would be more helpful to me.
Regards,
Nagarjuna
Attached the sample from my previous post (which has been also explained well by the following poster).