| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
update as you go along
Hi All
I have a line chart which is setup against an incomplete set of data. Therefore the line drops to zero on the chart when it reaches the incomplete bit see below Example Jan 10 Feb 20 Mar blank (line drops here) Apr blank May 0blank etc What I want is the line to go as far as the data and stop at that point. Then when I add the data it continues. Any ideas/suggestions greatly appreciated Rexmann |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
update as you go along
If the cells are really blank, a line chart will not draw those points. If
however you have a formula that looks like =IF(A3=0,"",A3) then the "" is plotted as a non-numeric text value, or zero. You can change the formula to: =IF(A3=0,NA(),A3) which gives the #N/A error in the cell, but which a line or XY chart will not plot. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "rexmann" wrote in message ... Hi All I have a line chart which is setup against an incomplete set of data. Therefore the line drops to zero on the chart when it reaches the incomplete bit see below Example Jan 10 Feb 20 Mar blank (line drops here) Apr blank May 0blank etc What I want is the line to go as far as the data and stop at that point. Then when I add the data it continues. Any ideas/suggestions greatly appreciated Rexmann |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
update as you go along
Hi
Nice one, thank you Worked a treat Cheers Rexmann "Jon Peltier" wrote: If the cells are really blank, a line chart will not draw those points. If however you have a formula that looks like =IF(A3=0,"",A3) then the "" is plotted as a non-numeric text value, or zero. You can change the formula to: =IF(A3=0,NA(),A3) which gives the #N/A error in the cell, but which a line or XY chart will not plot. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "rexmann" wrote in message ... Hi All I have a line chart which is setup against an incomplete set of data. Therefore the line drops to zero on the chart when it reaches the incomplete bit see below Example Jan 10 Feb 20 Mar blank (line drops here) Apr blank May 0blank etc What I want is the line to go as far as the data and stop at that point. Then when I add the data it continues. Any ideas/suggestions greatly appreciated Rexmann |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
| Data Validation lists update orginal cell with list update | Excel Worksheet Functions | |||
| i want to update one excel file the other one update automaticaly | New Users to Excel | |||
| keep value from last update and don't ask to update links | Excel Discussion (Misc queries) | |||
| Update / don't update dialog box | Excel Worksheet Functions | |||
Linear Mode
