Can't get chart to represent data correctly - 03 or 07

**indi** · 09-21-2009, 11:07 PM

I have attached a file with some data I need to chart. Each part number will have 3 weights, they do not start at zero. Each part number has 3 lengths that correspond with the 3 weights.

I have tried creating a line chart (cub type "Line with Markers displayed at each data value") but as you can see the lines do not fully join. Any suggestions for how to get a complete line on each data series?

Thanks.

**teylyn** · 09-21-2009, 11:39 PM

Hi,

Select the chart, then in Xl 2003 select Tools - Options - Chart tab (if the chart tab does not show, you have not selected the chart).

In the "Plot empty cells as:" radio buttons select Interpolated

Hit OK

viola!

**indi** · 09-22-2009, 12:21 AM

THANK YOU!!!!!! I would never have thought to look in the options dialogue box.

**teylyn** · 09-22-2009, 12:26 AM

Yeah, Microsoft managed to hide this setting quite effectively, especially since the chart tab only shows in the options box when you have a chart selected before you hit Tools - Options ...