| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2007 - Interpolate
Hi
How can I interpolate 2 poins in a Line Chart? In older versions of Excel this was so easy (Tools - Options - Graph - Plot Empty Cells As -- Interpolate. Thanks for your help. Joe |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel 2007 - Interpolate
Hi,
Select the chart and then within the Chart Tools tab Design Data group Select Data Hidden and Empty cells. Connect data points with line. Cheers Andy Joe wrote: Hi How can I interpolate 2 poins in a Line Chart? In older versions of Excel this was so easy (Tools - Options - Graph - Plot Empty Cells As -- Interpolate. Thanks for your help. Joe -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel 2007 - Interpolate - THANKS, Andy
Thanks, Andy.
"Andy Pope" escreveu na mensagem ... Hi, Select the chart and then within the Chart Tools tab Design Data group Select Data Hidden and Empty cells. Connect data points with line. Cheers Andy Joe wrote: Hi How can I interpolate 2 poins in a Line Chart? In older versions of Excel this was so easy (Tools - Options - Graph - Plot Empty Cells As -- Interpolate. Thanks for your help. Joe -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MS Excel does not interpolate empty cells | Charts and Charting in Excel | |||
| excel: how do i interpolate in an x-y data series? | Excel Worksheet Functions | |||
| interpolate | Excel Worksheet Functions | |||
| How do I interpolate numbers in Excel? | Excel Discussion (Misc queries) | |||
| Interpolate | Excel Worksheet Functions | |||
![Joe[_11_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
