I created a scrolling graph using the vlookup function. vlookup returns a zero for blank source cells. I want the blank. I have used "if" statements to see if I could return a blank. That works, but when I graph the data it still graphs a zero. I have clicked the "show empty cells with a gap" feature when I drilled into the selected data on the graph. Any ideas? I have a large number of data points. More than 900.
Also I want to graph vertical lines at certain points on the graph. For example a vertical line on Apr-2000. Excel comes back and states my data is too complex. I used the concept below. Any ideas on this?
Apr-2000 0
Apr-2000 30
Thank you in advance!!
Stan
Also I want to graph vertical lines at certain points on the graph. For example a vertical line on Apr-2000. Excel comes back and states my data is too complex. I used the concept below. Any ideas on this?
Apr-2000 0
Apr-2000 30
Thank you in advance!!
Stan