Showing zero values in line graph

walsh · November 30, 2010 10:26PM

I'm preparing a graph that plots a separate line for each different record type. It's a red/amber/green distribution, so when the filters are in use, it's not unusual for the red value to be zero. In this case, the red line stops or starts abruptly - I'd like to see the plot line continue along the zero line (on the attached example, the red line would continue from the 3 mark in Jul10 to the x axis and continue to Oct 10. Is there a way of making the graph do this?

Thanks,

Kevin

edward · December 1, 2010 11:58AM

The graph shows zero values for the red line if there are records visible with zero as their Y value (see attached). If the records are excluded, the line will stop, as the removed records may have non-zero values, and to show a line at zero would misrepresent the data. An absent line means 'there's no data', while a zero line means 'the data is here and it's value is zero'.

walsh · December 2, 2010 8:56PM

Ahh, I see. Thanks.

edward · December 21, 2010 10:58PM

Kevin,

The difficulty with axes in line smoothing is that if you don't want hard angles at the markers, you can't have rounded curves going through positive values and then tracking the x axis without them at least partially going below the axis. The solution is to either have less smoothing (but then have angles), or to turn off 'curves pass through points' in the Curve smoothing submenu. Have a look at the attached - all will become (smoothly) clear.

Edward

Welcome!

Categories

Ideas Parade