Hi,
I am trying to insert a pivot chart but none of the data series are appearing in the chart. The axes are there along with the legend but not the data itself. I've spent all morning trying to get it to work but can't see what I am doing wrong.
I can get a single series to appear if I use the SelectionName dropdown but I want all series together.
Can anyone see the problem?
I've uploaded the sheet here: Test.xlsm
Thanks
I am trying to insert a pivot chart but none of the data series are appearing in the chart. The axes are there along with the legend but not the data itself. I've spent all morning trying to get it to work but can't see what I am doing wrong.
I can get a single series to appear if I use the SelectionName dropdown but I want all series together.
Can anyone see the problem?
I've uploaded the sheet here: Test.xlsm
Thanks