HI
I have completed a bar chart in excel however the data label should read 1.33%
The figure that appears on the chart is 0.01%
I have checked the format of the data labels and it says Percentage to two decimal figures .
I read on the screen "percentage formats multiply the cell by 100 and disolay the result with a % symbol"
This explains why 0.01% appears but I do not know how to fix it.
Any guidance on how to change this is welcomed.
Unfortunately I am unable to post the spreadsheet as I do not have the facility to do this from my work pc.
Bookmarks