| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average Line created in an existing line graph- based on one cell | Charts and Charting in Excel | |||
| How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
| How do I make a line graph WITHOUT first line starting at zero? | Charts and Charting in Excel | |||
| How to change color of line and point markers on a line graph | Charts and Charting in Excel | |||
| Cluster stacked graph AND line combo graph? | Charts and Charting in Excel | |||
Linear Mode
