3 Replies Latest reply on Sep 26, 2016 11:48 AM by diego.medrano

    Blended Axis Does Not Inherit Formats

    Matthew Forrest

      Hi I have a workbook with several calculated fields that are formatted as a percentage. The calculated fields are very simple:

       

      SUM( [Column 1] ) / SUM( [Column 2] )

       

      These are all set to have the number format as a percentage with one decimal place.

       

      When I put one of these fields onto a simple line graph, the vertical axis is correctly formatted as a percentage.

      However, when I add even one more field to create a blended axis, the axis converts to a decimal format.

       

      I'd like to have many of these fields (5-8) on the same blended axis.

       

      Is this working as intended? Is there any way to force the axis to format as a percentage?