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?