If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Line chart - date line association gone mad! | Johannes Czernin | Charts and Charting | 5 | January 17th, 2005 08:48 PM |
Line chart zero values | Walshy | Charts and Charting | 4 | June 16th, 2004 04:09 PM |
Discontinue part of line in chart | Jon Peltier | Charts and Charting | 0 | April 1st, 2004 10:27 PM |
Trying To Add a Line to an Excel chart using variable cell values | Larry Campbell | Charts and Charting | 2 | January 24th, 2004 05:31 PM |
Plotting a datapoint on an existing Line chart | Tushar Mehta | Charts and Charting | 0 | November 23rd, 2003 01:08 AM |