I have successfully created a chart in which the data series refers to a pivot table that can be controlled by a slicer. The slicer has 3 buttons 'Count', 'Cost' and 'Percentage'. Although the chart series correctly references the right data the y-axis is not displaying the correct number format. For example, if I select Percentage after selecting Cost the units will remain as £ rather than %. I've formatted the values in the pivot but this seems to make no difference. Any clues how I can fix ?