2 Lined Line Graph
 

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?

2 Lined Line Graph
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Steve" wrote in message
...
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?

2 Lined Line Graph
 

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

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Steve" wrote in message
...
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?

2 Lined Line Graph
 

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



"RPAC" wrote in message
...
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

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Steve" wrote in message
...
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?