Hi, I need your help if possible, I need help with formating a set of cells, and at present I am little stumped.
I have a spreadsheet which is linked to a database via Olap cube's, the data is presented in a pivot table showing month on month sales figures, but where we have no data, for example Jun-08, the value is represented as £0.
From the out put of the pivot table, I generate a graph to show the data with a trend line on, this is where the issue kicks in, because the cells show a £0 value the trend line is driven in a negative direction, for it assumes there has been no sales for the rest of the year.
To try and get around this, I mirrored the data =C1R1 for example, with a formula =IF(A1>0,A1,""), great this removes the £0, but the trend line is still driven negative, the only time it is not driven negative is when the cell is blank, how do I format the cell as blank ???