software

Hello,
I want to create a lineal graphic, but when there are not all the values of
the table of values, it does not paint the complete lines, but only the
consecutive points of measurement. One cannot paint a line from one value to
other skipping one or two columns of for way?

Example:

|A|1|2|3|4|
|B|1| |3|7|
|C|1|3|4|5|

The 'B' should paint a line from the value 1 to the value 3 and from value 3
to 7, but only one marks me the value and later a line of the value 3 to the
value 7.

How can I paint her does it complete?

Thank you.

Hi,

Select the chart and then use the menus Tools gt; Options gt; Chart.
Plot Empty cells as: Interpolated.

Cheers
AndyMiguel Angel wrote:
gt; Hello,
gt; I want to create a lineal graphic, but when there are not all the values of
gt; the table of values, it does not paint the complete lines, but only the
gt; consecutive points of measurement. One cannot paint a line from one value to
gt; other skipping one or two columns of for way?
gt;
gt; Example:
gt;
gt; |A|1|2|3|4|
gt; |B|1| |3|7|
gt; |C|1|3|4|5|
gt;
gt; The 'B' should paint a line from the value 1 to the value 3 and from value 3
gt; to 7, but only one marks me the value and later a line of the value 3 to the
gt; value 7.
gt;
gt; How can I paint her does it complete?
gt;
gt; Thank you.

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

Select the chart. Then select Tools | Options... | Chart tab. In there set
the option for 'Plot empty cells as' to 'Interpolated'.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article gt;, =?Utf-8?B?
TWlndWVsIEFuZ2Vs?= lt;Miguel gt; says...
gt; Hello,
gt; I want to create a lineal graphic, but when there are not all the values of
gt; the table of values, it does not paint the complete lines, but only the
gt; consecutive points of measurement. One cannot paint a line from one value to
gt; other skipping one or two columns of for way?
gt;
gt; Example:
gt;
gt; |A|1|2|3|4|
gt; |B|1| |3|7|
gt; |C|1|3|4|5|
gt;
gt; The 'B' should paint a line from the value 1 to the value 3 and from value 3
gt; to 7, but only one marks me the value and later a line of the value 3 to the
gt; value 7.
gt;
gt; How can I paint her does it complete?
gt;
gt; Thank you.
gt;

quot;Miguel Angelquot; lt;Miguel gt; wrote in message
...
gt; Hello,
gt; I want to create a lineal graphic, but when there are not all the values
gt; of
gt; the table of values, it does not paint the complete lines, but only the
gt; consecutive points of measurement. One cannot paint a line from one value
gt; to
gt; other skipping one or two columns of for way?
gt;
gt; Example:
gt;
gt; |A|1|2|3|4|
gt; |B|1| |3|7|
gt; |C|1|3|4|5|
gt;
gt; The 'B' should paint a line from the value 1 to the value 3 and from value
gt; 3
gt; to 7, but only one marks me the value and later a line of the value 3 to
gt; the
gt; value 7.
gt;
gt; How can I paint her does it complete?
gt;
gt; Thank you.

Tools/ Options/ Chart:

Plot empty cells as: interpolated
--
David Biddulph