I have a pivot table with matching chart. I used the layout function to get
it how i want but in the data section there is 2 types of data. They apear
fine and i can read them and see them in the chart ok, but if i want to
select just one to see it on its own i can , but the one i didn't select the
option is missing from the list. Taking the data out. Both sets of data are
set as Sum, but on other pivot tables i have done in the past this has worked
when i have been using count.

Any ideas

Thanks