13 Replies Latest reply on Oct 20, 2012 7:56 AM by Alex Kerin

    Why would a reference line value change between a bar and a line graph, all else being equal?

    Michael Mixon

      I encountered something very odd today.  I put together a relatively simple chart, utilizing a table calc Window Avg, but when I add a reference line to the chart, the value of the reference line changes depending on whether I use a bar graph or a line graph.  Everything else is identical between the two charts, so I'm at a loss as to why this would change.  The line graph reference line value is the correct one, by the way, but I can't seem to get it to show up using any other chart type other than line.

       

      I've attached a Word doc that shows the relevant screen shots.  Can anyone explain this behavior, and more importantly, help me bypass it?

       

      Thanks in advance.

       

      -Mike