Chart question
 

I have a chart where I'm plotting variance on a 2nd axis. I have several
series on the 1st axis. I am showing a data table. I'm showing a horizontal
series line at zero variance but it is trivial to include this zero series in
the data table. Any way of not including a plotted series in the data table,
either by code or chart setup?
TIA
--
David

Chart question
 

You can place a line object on the chart. Assuming you know the value
you want the line to represent, you can locate it vertically by:

(Y scale max - Y scale min) * value represented * plot area height +
plot area top

I can show you some code where I place a vertical line. Same concept,
slighly different plot area properties.

HTH,
John