Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How do I show the top 5 (by value) and have the 6th line as "Other" with a sum of the rest of the table?
Many thanks.
Hi,
Go to Chart property->Dimesion Limit->
Regards,
Hi Stephen,
use Dimension Limits as shown:
HTH - Andy
thanks Andy, is it possible to have this "others" line in the same format as D1, D2 etc?
Almost, right click the cell and use 'Custom Cell Format' (use - View Design Grid if you don't have the option displayed) and you can get it like this:
i.e no bold or background colour
Andy
ye that works for me! thanks again
No problem! Have a good day!
Andy