Excel 2007 and missing(?) interpolate Chart option

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GT-Force - 10 Apr 2007 05:36 GMT

Hi,

Is there anyone here who knows whether the interpolation function in the
chart options in Excel 2003 was omitted in Excel 2007, or was moved to
somewhere hard to find? If moved, where to?

Thanks.

GT

PS: I know that I can use the =NA() to connect the gaps in the line-graphs,
but the chart option does that automatically to all the missing data points,
and therefore, it was better.

Reply to this Message

Bernard Liengme - 10 Apr 2007 13:58 GMT

That feature ("function" has a very specific meaning in Excel) is still
there. Follow this path:
click the chart; use Chart Tools|Design|Selected Data; look for button
labelled "Hidden and Empty Cells"; complete dialog box as needed.
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Hi,
>
[quoted text clipped - 9 lines]
> line-graphs, but the chart option does that automatically to all the
> missing data points, and therefore, it was better.

Reply to this Message

GT-Force - 12 Apr 2007 01:36 GMT

Thanks a lot Bernard, you saved my sanity :)
When I was looking around trying to find this feature, I bumped into this
place that you mentioned. But for whatever reason, apparently my brain only
registered the "hidden" part, and completely skipped the "empty cells" part.
The funny thing is, besides searching this feature as interpolation, I also
searched about this feature as gap(s) and chart(s), and yet no search
results came out from any Microsoft help resource, and yet, there it is, one
of the radio buttons has Gaps next to it! Sigh...
GT

> That feature ("function" has a very specific meaning in Excel) is still
> there. Follow this path:
> click the chart; use Chart Tools|Design|Selected Data; look for button
> labelled "Hidden and Empty Cells"; complete dialog box as needed.
> best wishes

Reply to this Message

Rate this thread: