Format expression totals

[#1]

I have selected an option on the expression tab to use a total. For example I am including a numeric count of rows total option for an expression which then appears as a line at the top of my chart. This works fine but I would like to be able to make that total (including the label) bold, a different color text ,or a different color background so that it stands out a bit more than the rest of the rows in my straight table. Any ideas on if this can be done? I have tried to set the text format of the expression itself but then this affects the whole expression column while I only want it to affect the total line and the total label.

Thanks!

[#2]

Look here:

Chart Properties - Presentation Tab - Text in Chart (not for table type charts)

[Oleg_Troyansky · Accepted solution]

Turn on "Design Grid" (in the View menu), then right-click within the total cell and select "Custom Format Cell" from the context menu. You will be able to control font, color and other attributes there.

Oleg

[#4]

My suggestion is not for table type charts, sorry for the misunderstanding

Thanks for the tip Oleg, never noticed this option before.

[#5]

Thanks so much, this is very helpful!

[#6]

Thanks Oleg, this tip is great. I have two more questions:

1) Unfortunately, I can't SAVE in THEME the options I define for the colors in the Subtotals. Is this possible?

2) I can't define different background/text color for the different levels of subtotals. Is this possible as well?

Thank a lot in advance.

BR

Kalin