Make value field selectable

[Jonathan9]

Hi,

I have one slight issue with at pivot line chart I'm making. Under the value field I'm going to have many different values but since it's quite a few it will become rather messy so I would like to have the option to choose between the different values.

This is very possible with the variables that are under row label, in this instance month - but for some reason it's not possible with the variables under values.

Any ideas on how to solve this?

Thanks!

[Olly]

Attach a workbook, rather than an image, please.

[Olly]

Ah, X and Y are separate fields, aren't they - rather than being separate values in the same field...

[cbatrody]

Hi,

Yes, you should be able to filter the variables under the row label if you have connected the chart to a Pivot Table.