If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
plotting line charts with formula based 'gaps'
Hi,
The use of NA() only removes the data markers it will not cause a break in the line. The line will be interpolated between any data points that have a numeric value. You can see the variations here. http://www.andypope.info/charts/brokenlines.htm Cheers Andy Bernard Liengme wrote: The NA() part of the formulas cause the chart engine to ignore the cell and joint adjacent points. If you rewrite the formulas in the form =IF(AND(A12,A16),A1,"") you will get gaps when the cell displays a blank best wishes -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#12
|
|||
|
|||
plotting line charts with formula based 'gaps'
That still won't provide a gap...
- Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Bernard Liengme wrote: Can you change the formula to enter NA() when the plotting data is not available Show us the formula so we may help you better best wishes |
|
Thread Tools | |
Display Modes | |
|
|