pivot chart

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?

i mean i want to see just one chart from these four charts. is ti possible?

thank you

i attached the picture

Attached Images

Unbenannt (1).jpg (78.4 KB)

pivot chart