Evan Amies-Galonski
New member
- Joined
- Jan 31, 2012
- Messages
- 1
- Reaction score
- 0
- Points
- 0
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?