Bernard,
That worked for bridging the gaps in the line plot, but not the area chart.
The area chart has the "connect" grayed out. Also, if I enter =na(), it
treats them as 0's and doesn't interpolate.
Any suggestions?
"Bernard Liengme" wrote:
Click the chart to activate it
In the Design tab of Chart Tools, click Select Data
A dialog box opens, look at lower left corner for "Hidden and Empty Cells"
button and click it
You get three options: gaps, zero and connect.
Alternative (works in all version of Excel); in the empty cell type =NA().
It will display as #N/A and will be ignored by the chart engine
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"BABs" wrote in message
...
XL 2007 doesn't have the TOOLS-Options-Interpolate menu and choices.
This goes for a line chart as well.
Thx