Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel 2010, how do I set a chart to treat missing data points as zero?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2010 - Line Chart with Mulitiple Data Sets | Charts and Charting in Excel | |||
half way though chart, lines between data points missing | Charts and Charting in Excel | |||
Line charts with missing data points in Excel 2007 | Charts and Charting in Excel | |||
How do I chart missing data points in a scatter graph? | Charts and Charting in Excel | |||
creating a chart with auto fillin of missing date points? | Charts and Charting in Excel |