Forum Discussion
Solved
Can't change format of Excel chart horizontal axis
Hi ... I searched the web and cannot find the answer as to why I can't change the format of the horizontal axis. The data comes from a percentage formatted spreadsheet, and the axis is percentage fo...
I'm curious how you did those 4 columns (Percent, Value, Row Labels, SOV). I can't seem to replicate that. Thanks
Not sure which 4 columns do you mean.
Another guess - perhaps creating PivotTable you added data to data model. In this case row labels will be shown as decimal numbers and you can't change format for row labels.
If simply apply another format in grid that won't affect PivotTable itself. What could be done is to add calculated column with proper format
If use this new field in PivotTable it will be shown as text representation of percent
File with above sample is here.