Adding an empty row in a pivot chart

[#1]

Hi,

to format a pivot chart with one dimension (Amount Type) on rows and two dimensions (Year and Month) on columns I need to insert an empty row to act as a separator with fe gray background colour. For this empty row I have set a particular value for the Amount Type dimension.

Any suggests in order to add a conditioned formatted empty row, please?

Thanks

[#2]

Not sure your exact requirements, but how about creating an expression formula:

=''

or

=null()

[#3]

Hi,

I've partially solved by load a dummy row with fictitious values for my dimensions, but now I'd like fe to format the background of this dummy row added, without affecting the background of other rows.

Thanks

[rwunderlich]

You should be able to do something with the Background color property in the Dimension. Click the plus next to the Amount Type dimension.

=if([Amount Type]='mydummy', grey())

[#5]

In the pivot chart I cannot see any background colour properties for a dimension.

Thanks

[rwunderlich · Accepted solution]

In the Dimensions tab of the chart properties, Click the "+" next to your dimension name. Then select "Backgound Color" and press the edit button.

Correction to my earlier example. There is no "grey()" function. Use a valid function name 🙂

[#7]

Ok, thanks, I've solved.