1 Reply Latest reply: Oct 17, 2014 10:42 AM by Anna Anna RSS

    Axis value (offset)

      Hi everyone

       

      I'm trying to build a bar chart, similar to the one below, displaying the availability of machines. The target availability is 97 %, and I would like to display machines that have a higher availability as an rising bar, and a dropping bar for machines with a lower availability. I also want to display the actual values.

      availability.JPG

      Unfortunately, I cannot find a way to achieve this. I tried working with a 97 % offset, but that would mean that a 99 % value is displayed as 2%, and a 95 % availability as -2 %. So the bars are shown correctly, but not the values themselves.

       

      I would have expected that this would be possible, since this is a pretty standard functionality in Excel as well.

       

      Any ideas, anyone?

       

      Thanks,

      Frederic