Customizing Gauge on the Pivot Table

[triekong]

i have a pivot table. i have set one of the columns to "linear gauge".

i am having trouble customizing the gauge bars in the column, i would like it to be thinner (not fill up the entire cell). i have tried editing the gauge settings in the 'expressions' tab, but none of the settings are accommodating this.

i also tried changing the multiline settings in the 'presentation' tab; the problem with this is, it changes the sizes of all the cells in all the columns, instead of just the cell containing the bar.

is it possible at all? or anyone know a workaround?

i have attached the QV document here.

Thanks!

[krishnacbe]

Hi

Hope you have set the Wrap option to 4, if you uncheck the option the bar height got reduced automatically.

[triekong]

thanks for your response!

but the problem is, it reduces the height of the row cells as well. i only want to reduce the height of the linear gauge to make it thinner.

i like the cell height as is, just don't want the gauge to fill up the entire cell space