Struggling to change the axis format of a chart

[tsakta13ole]

Hi. I'm attaching my workbook. On the chart with the title "Based on events" I'm trying and failing to change the format in the axis. Where you see 0.0399, 0.0500000 etc I would like these to turn into percentages (3%, 4% etc). In the number tab in the category option I have changed to percentage to no avail.

Thanks for any help!

Barclays question.xlsm

[tsakta13ole]

Does anyone know?

[romperstomper]

Remove the blank rows from your data source and change the source for the pivot so that it doesn't extend past your data. You can then format the axis because it will be treated as numeric rather than text.

[tsakta13ole]

Thank you for your answer.
By "remove the blank rows from your data source" you mean to delete the rows? I did that, I then went to the first pivot and changed the data source to the new ($A$3:$M$394, 394 because I deleted some data I didn't want) and now the pivot doesn't work.
I attach my updated workbook.Barclays results pivots.xlsm

[romperstomper]

It does work - you just need to make some room (it's never a good idea to put 2 pivots too close together) so that you can add the event field back in and then filter it as required. See attached version.

[tsakta13ole]

Ok thank you!

[romperstomper]

Glad to help.