Skip to main content

Has anyone run into a number alignment issue on a dual axis table. 

 

See the attached workbook, created in 10.5- It works fine as a single axis- but when I tried to do some dual axis trickery to be able to create a background fill as well as color the text it seems that the numbers no longer line up correctly.  Specifically I am looking at CSG Quality Composite Score, as well as RUAT.

 

Any suggestions would be greatly appreciated.

 

Thanks,

Scott

5 answers
  1. Aug 9, 2018, 9:45 PM

    The numbers are not aligned because of the different max values. so, what you need to do is use a constant value, e.g. 1, and then display the required value(s) as a label over them. I am using the average of number of records in the image below. This will always be 1.

    The numbers are not aligned because of the different max values. so, what you need to do is use a constant value, e.g. 1, and then display the required value(s) as a label over them.

    Hope this helps.

0/9000