2 Replies Latest reply: Jul 20, 2011 7:58 AM by Anne Duffy RSS

    Standard Line on Bar/Line Chart

      Hi Guys,

       

      I have a bar/line chart that shows the average number of activities by person. The Optimum number that should be processed is 47.

       

      I wish to have a line that crosses the graph at 47.

      I have intially loaded it from a excel sheet, but when an option from a list box is selected to get a drill down view - this optimum line disappears, as its not relative to the list selection - Can I LOCK this line in at 47 ?

       

      I have tried by not using a formula and just writing the demension at 47, but then it will extend out over the reporting period, see picture below.

       

      Can anyone help with this please ?

       

      Graph long optimum.bmp