I have a bar chart which has around 15 bars on it all of which have a different % associated with each one.
I only want to show the top 5 bars ie. the bars which have the highest 5 % values.
Does anyone know how to do this?
Use "Max Visible Number" on the "Presentation" tab
Thanks for your answer - as I have 3 dimensions this does not seem to work as it only picks the first n where n is the number i enter into "Max Visible Number"
Have you got any other ideas?
Retrieving data ...