Forum Discussion

RobD2111's avatar
RobD2111
Copper Contributor
Jan 12, 2022
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 formatted as well, but it appears as decimals.

 

Thanks,

Rob

6 Replies

    • RobD2111's avatar
      RobD2111
      Copper Contributor

      SergeiBaklan 

       

      Exactly right.  I cannot get the bottom axis to show %.  Whatever I do it remains decimal.  Please see below.  Thanks

       

       

       

       

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor

        RobD2111 

        Okay, that's PivotChart. In general also shall work

        Perhaps you may share sample file ?

Resources