 |
|
|
Also see our huge range of Charting Software . Got a Excel Chart question? Use our FREE Excel Help !
Back to Excel Charts Index
Non zero data returned from a formula is treated as zero. The use of NA() allows the line to be joined between numeric points
The mask method can be used to create breaks for missing data.
| Original Data | Linked Data "" | Linked Data #N/A | Linked Data Masked | Mask | |
| 0.28 | A | 1.28 | 2.28 | 3.28 | #N/A |
| 0.25 | B | 1.25 | 2.25 | 3.25 | 3.25 |
| 0.01 | C | #N/A | #N/A | #N/A | |
| 0.35 | D | 1.35 | 2.35 | 3.35 | 3.35 |
| 0.07 | E | #N/A | #N/A | #N/A | |
| 0.87 | F | 1.87 | 2.87 | 3.87 | 3.87 |
| 0.72 | G | 1.72 | 2.72 | 3.72 | #N/A |
| 0.88 | H | 1.88 | 2.88 | 3.88 | #N/A |
| 0.21 | I | 1.21 | 2.21 | 3.21 | #N/A |
| 0.34 | J | 1.34 | 2.34 | 3.34 | #N/A |
| 0.40 | K | 1.40 | 2.40 | 3.40 | #N/A |
The example workbook contains a formula to create the mask data series
Back to Excel Charts Index
Also see our huge range of Charting Software
Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel
| MSSQL Migration
Toolkit |
Monte Carlo Add-in |
Excel
Costing Templates