how to ingore cells or enter only specific cells as chart values?
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?
First try setting the option for Hidden or Empty cells to Connect datapoint with line. This will cause the contents of column C to plot.
Min and Max columns have no values at all so not sure what you expect to see. I think you need to transfer the rows of values in to columns.
For the "2010 Daily discharge" values those for Jan through mid Mar will plot as zero as the cell contains text not numeric values. The spikes in Dec are also caused by text instead of numeric data.
Hi,
Cross posted thread
See attached a solution
May be Andy will give us a better solution for charting mean, max and min value per month
Hope this helps
Best regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks