| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I stop plotted data from going to zero in a line chart?
Text in cells are plotted as zeros in Excel 2003 with Windows XP.
|
|
#2
|
|||
|
|||
|
Use #N/A instead of text.
Jerry Dozier wrote: Text in cells are plotted as zeros in Excel 2003 with Windows XP. |
|
#3
|
|||
|
|||
|
I have multiple columns and enter tradiing (commodity) date daily. Formulae
are in the columns which become values when the daily data is entered. I have been using Lotus and am trying with difficulty to convert to Excel "Dozier" wrote: Text in cells are plotted as zeros in Excel 2003 with Windows XP. |
|
#4
|
|||
|
|||
|
Formulas must return sumething (Excel has no missing or empty cell
value). Anything other than a number or a #N/A will plot as zero. Either write an event driven macro to add the formula only when the data is available, or else use a formula like =IF(INUMBER(dailyData),formula,#N/A) as I suggested yesterday. You can use a conditional format to hide the display of error values in the cells if the worsksheet appearance bothers you. Jerry Dozier wrote: I have multiple columns and enter tradiing (commodity) date daily. Formulae are in the columns which become values when the daily data is entered. I have been using Lotus and am trying with difficulty to convert to Excel "Dozier" wrote: Text in cells are plotted as zeros in Excel 2003 with Windows XP. |
|
#5
|
|||
|
|||
|
Thank you. However I must be doing somethng wrong and I just foound it. I had
not copied the formulae to the end of the date. All is well. The work appearance does not bother me. Thanks Dozier "Jerry W. Lewis" wrote: Formulas must return sumething (Excel has no missing or empty cell value). Anything other than a number or a #N/A will plot as zero. Either write an event driven macro to add the formula only when the data is available, or else use a formula like =IF(INUMBER(dailyData),formula,#N/A) as I suggested yesterday. You can use a conditional format to hide the display of error values in the cells if the worsksheet appearance bothers you. Jerry Dozier wrote: I have multiple columns and enter tradiing (commodity) date daily. Formulae are in the columns which become values when the daily data is entered. I have been using Lotus and am trying with difficulty to convert to Excel "Dozier" wrote: Text in cells are plotted as zeros in Excel 2003 with Windows XP. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
| Excel Charts - Data being Plotted beyond Primary X-Axis Scale | Charts and Charting in Excel | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions | |||
Linear Mode
