Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
You want the font size to be bigger or can you just make it bold?
Thank you. i need it bold and text size bigger
I think text size might be an issue and you may have to look into a macro to do this
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!
Something along these lines
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