2 Lined Line Graph

[Steve]

I am trying to plot quarterly and monthly data using two lines. My quarterly
line is broken into points instead of a continuous line, is there a way I can
get it to connect to the quarter points?

 

[Jon Peltier]

If the cells in between are blank, go to Tools menu > Options > Chart tab,
and choose the Interpolate option for dealing with blank cells. If the cells
contain anything else, including a formula that returns "" (which is NOT
blank), change "" to NA(), which puts an #N/A error in the cell, which ain't
pretty in the worksheet but which results in an interpolated line in the
chart.

- Jon

 

[RPAC]

How can you interpolate values on Excel for the Mac (Excel 2004). There is no
"Options" option under Tools. And The "Chart Options" dialog box, doesn't
give the option to interpolate.

Help!

-Preet

 

[Mike Middleton]

Preet or RPAC -

In Mac Excel 2004, select the chart, and choose Excel | Preferences | Chart
| Active Chart Empty cells plotted as Interpolated.

Most of the Tools options in Windows Excel are available in Mac Excel via
Excel Preferences.

For Mac-specific questions, a very active newsgroup is
microsoft.public.mac.office.excel

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel