Text format - expression in chart

[#1]

Hi,

I have a chart with 2 calculated  expressions in the same cell by using chr(10)

sum(Price)
&chr(10)&
sum(Units)/sum(TotalUnits)

The cell looks :

I want to change the format of the first expression to be bigger.(500)  i cant use the text format because the all cell text is changing

any why to do it?

[Chanty4u]

for  two metrcis same size means you need to go  font tab

orelse  u need to create two seperate text objects and incorporate into single

HTH

[sunny_talwar · Accepted solution]

You want the font size to be bigger or can you just make it bold?

[#4]

Thank you.  i need it bold and text size bigger

[sunny_talwar]

I think text size might be an issue and you may have to look into a macro to do this

[#6]

O.K.

So how can i use it in a chart with dimmention of 10 or more values?

I want the first row of the total to be bold....

Thank you!

[sunny_talwar]

Something along these lines

[#8]

Thank you Sunny.

This looks good... but,

1.how can i use it if the list of products is dynamic and i don't know all the values in it?

2. can it be presented in a straight table chart and not pivot table?

Thank you