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 |
#1
|
|||
|
|||
charting blank spots
Hi.
I'm working with automating a chart that the user has filled in by hand, in the past. The chart displays a years worth of data, and she just manually filled in the new month's data for each successive month. One way to automate things is to fill in formulas that result in the proper data for months that have transpired, and "" for months yet to come. The problem with this is that the chart displays the text blank, "", as a 0 . One of the series in the chart is displayed with a line, and for the months that have not yet occurred, the line goes down to 0, and then stays there. Is there a setting to prevent the chart from dispaying a text item as 0? If not, I can programatically update the thing, but it would be simpler not to. |
#2
|
|||
|
|||
charting blank spots
Using "" does make the graph take a nose dive. Use the
function na() instead as your graph will treat this command as a null. -----Original Message----- Hi. I'm working with automating a chart that the user has filled in by hand, in the past. The chart displays a years worth of data, and she just manually filled in the new month's data for each successive month. One way to automate things is to fill in formulas that result in the proper data for months that have transpired, and "" for months yet to come. The problem with this is that the chart displays the text blank, "", as a 0 . One of the series in the chart is displayed with a line, and for the months that have not yet occurred, the line goes down to 0, and then stays there. Is there a setting to prevent the chart from dispaying a text item as 0? If not, I can programatically update the thing, but it would be simpler not to. . |
#3
|
|||
|
|||
charting blank spots
Using "" does make the graph take a nose dive. Use the
function na() Thanks. |
Thread Tools | |
Display Modes | |
|
|