Fairly new to excel. I have created a pivot table and organised it to display what I need. When creating a pivot chart, when I create a slicer I cannot filter the data/rows I want to view. It may be that I need to add something to the raw data or that I need to change my pivot table/chart fields.
I want to be able to remove and add in the different columns. I.e on my pivotchart filter/slicer in order to hide or show the different columns so I can see them plotted against each other. When I put in a slicer the options it gives me only the values of the columns. What i want to add/omit is the coloms/lines themselves.
I want to be able to remove and add in the different columns. I.e on my pivotchart filter/slicer in order to hide or show the different columns so I can see them plotted against each other. When I put in a slicer the options it gives me only the values of the columns. What i want to add/omit is the coloms/lines themselves.
