In Excel 2010, how do I set a chart to treat missing data points as zero?

**Peter Rubenstein** · June 29th 12, 03:42 PM posted to microsoft.public.excel.misc

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.

**Peter Rubenstein** · June 29th 12, 03:50 PM posted to microsoft.public.excel.misc

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2010 - Line Chart with Mulitiple Data Sets	Dukegijoe	Charts and Charting in Excel	1	May 29th 12 08:07 PM
half way though chart, lines between data points missing	Caminoel	Charts and Charting in Excel	0	February 24th 10 12:19 PM
Line charts with missing data points in Excel 2007	turen	Charts and Charting in Excel	2	August 22nd 07 06:08 PM
How do I chart missing data points in a scatter graph?	mickey	Charts and Charting in Excel	2	October 11th 06 11:43 PM
creating a chart with auto fillin of missing date points?	Rob	Charts and Charting in Excel	2	March 20th 05 03:12 PM