Hi
This is probably a very basic question but i am just starting with pivot tables and was wondering how i do the following:-
In the attached i am trying to show jans data for three years all in the same colour, then febs in another colour etc so that each site can see the trends in each month for each year, i can change these but they refer back to random colours.
if i deselect jan 2015 it removes it from the graph but if i re select it it does nor re appear, even if i refresh the data.
am i just been an idiot here?
Regards
Peter
Bookmarks