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
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.
Hope this helps.