Pivot chart

[JHB]

You're welcome!
BUT did you read my signature or ...?

 

[mana]

what is your signature?

 

[mana]

Hi

i have another question
do you know it?
i have a chart with four fields in data area and i want that the scale would be set based on the most value of these four fields
do you know how to do this?
and also can i have a dropdown to choose just one of these fields to show?
thank you
i attached the picture