Results 1 to 2 of 2
  1. #1
    Join Date
    May 2005
    Posts
    125
    Provided Answers: 1

    Question Unanswered: Formatting Cells

    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 ???

  2. #2
    Join Date
    May 2005
    Posts
    125
    Provided Answers: 1
    droped the NA function into the formula, the graph does not recognise #N/A as a figure

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •