On 10/12/2011 06:40 Jim Cone wrote:

Use a line-column chart. Include the average column as part of the source range.
"#N/A" is not plotted when used as data for a chart.
So modify your formula(s) to use #N/A as the alternate value instead of "".

Brilliant: thank you! And so simple!

--
F