|
| 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
September 2nd, 2009, 01:06 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
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
September 4th, 2009, 02:32 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 | |
|
|
Linear Mode
