Ok I need to build a chart that trends 3 different KPI. I can build a chart that has 2 y axis no problem - the first shows a stacked bar whilst the second shows a line chart. I need to add another line chart on there however the problem is the scale of the new line is so far above the scale of the existing line that it throws off the scale.
Anyone any idea on how i can do this. Is it possible to 'compress' the sclae of the second y axis - i.e the bottom half of the scale is 0.1 - 0.9 whilst the top half is 50 - 150.
Hope this makes sense - any help you can give is much appreciated
Anyone any idea on how i can do this. Is it possible to 'compress' the sclae of the second y axis - i.e the bottom half of the scale is 0.1 - 0.9 whilst the top half is 50 - 150.
Hope this makes sense - any help you can give is much appreciated