Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
cannot check interpolate
tool - options - chart cannot check interpolate so the missing data between
my data set interpolates to value |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
cannot check interpolate
This setting is available only for line and XY charts. (It's also available
for Area charts, but does not cause interpolation of the data). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Tarra" wrote in message ... tool - options - chart cannot check interpolate so the missing data between my data set interpolates to value |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
cannot check interpolate
thanks John, it is a combinmed line and bar chart and the data set i am
trying to interpoolate is graphed as a line - any suggestions? "Jon Peltier" wrote: This setting is available only for line and XY charts. (It's also available for Area charts, but does not cause interpolation of the data). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Tarra" wrote in message ... tool - options - chart cannot check interpolate so the missing data between my data set interpolates to value |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
cannot check interpolate
Two ways:
1. Make the chart as a line chart, choose the Interpolate behavior, then change the other series to a column type. 2. Put #N/A into the blank cells in the line chart's source data, which will make Excel interpolate across the gap. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Tarra" wrote in message ... thanks John, it is a combinmed line and bar chart and the data set i am trying to interpoolate is graphed as a line - any suggestions? "Jon Peltier" wrote: This setting is available only for line and XY charts. (It's also available for Area charts, but does not cause interpolation of the data). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Tarra" wrote in message ... tool - options - chart cannot check interpolate so the missing data between my data set interpolates to value |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allowing only 1 check box to be ticked | Excel Discussion (Misc queries) | |||
Copying forumla for vlook up but changing the column Index # | Excel Worksheet Functions | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
Check boxes I have inserted in Excel move when I print? | Excel Discussion (Misc queries) | |||
Can Not Check more than 1 check box | Excel Discussion (Misc queries) |