Results 1 to 2 of 2

Thread: How do ignore cells in chart, or select only specific cells for chart?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Question How do ignore cells in chart, or select only specific cells for chart?

    OK so I'm making graphs for yearly discharge of river systems and this requires my to enter a value for every day of the year. I also need to have means, maximums and minimums for each month. This means i need to have only 1 value for each month of the year. I'm having trouble putting both of these things into the chart because there are blank spaces between all of the cells for the monthly means, maximums and minimums since all of the cells adjacent to them are filled. Excel takes each of the blank cells as a value of 0, and its making my graph wrong, so my question is, how do i get excel to ignore the blank cells?
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

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