Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line chart even though values missing
I notice that my line chart doesn't draw a line if there are missing values. For example, I'm charting weight by date. But if I don't weigh myself on every single day, the line stops at the last day of a cluster of daily weights. Is there a way to have the dots be connected even if there are intervening missing data points? Thanks! -- MattBeckwith ------------------------------------------------------------------------ MattBeckwith's Profile: http://www.excelforum.com/member.php...o&userid=30571 View this thread: http://www.excelforum.com/showthread...hreadid=502199 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line chart even though values missing
Hi,
If the cells are really empty the you can get the chart to interpolate between the points. Select the chart and then use menu Tools Options Chart Plot empty cells as Interpolated. Cheers Andy MattBeckwith wrote: I notice that my line chart doesn't draw a line if there are missing values. For example, I'm charting weight by date. But if I don't weigh myself on every single day, the line stops at the last day of a cluster of daily weights. Is there a way to have the dots be connected even if there are intervening missing data points? Thanks! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add a vertical line to a Line Chart that aleady has 2 Y axi | Charts and Charting in Excel | |||
Line chart or scatter chart?? | Excel Discussion (Misc queries) | |||
Null points in a line chart | Excel Discussion (Misc queries) | |||
Activating a Chart object | Charts and Charting in Excel | |||
Missing values in Excel Line Chart | Charts and Charting in Excel |