View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peter Rubenstein Peter Rubenstein is offline
external usenet poster
 
Posts: 2
Default In Excel 2010, how do I set a chart to treat missing data pointsas zero?

Sorry forgot to mention I'm using Microsoft Office Professional Plus
2010

On Jun 29, 10:42*am, Peter Rubenstein wrote:
My data looks like this:

5/21/12 10:00 * 738
5/21/12 13:00 * 2
5/21/12 14:00 * 272
5/21/12 18:00 * 326
5/21/12 22:00 * 857
5/22/12 15:00 * 136
5/22/12 18:00 * 43
5/22/12 20:00 * 294
5/22/12 21:00 * 300

I'd like for my chart to fill in the missing hours as zero values.
Help appreciated.