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...
Exactly right. I cannot get the bottom axis to show %. Whatever I do it remains decimal. Please see below. Thanks
- 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.
- Thanks Sergei. Interesting, I was thinking about doing the same thing (creating separate data columns), but didn't know how to go about it. It's frustrating that we have to do that for the axis to display %,, but we do what we must!
Can you please share the SOV cell formula so I can implement it?
Thank you!
Rob