Continious Point

Hi Manoc
have a look at
http://www.tushar-mehta.com/excel/ch...nes/index.html

Frank

Manos wrote:
Dear all
i have a line chart with two lines, and everything is fine
the problem is that i want to add a 3rd line but for that
line i have only one value that i want it that value to
repeated for 12 times in order to have a total line and
not only the starting point

The issue is that i don't want to add in the excel table
to add 12 columns with the same value.
There is anyway that the chart can repeat the same value?

Thanks in advance
Manos

Manos -

You could put the data in a different place than the rest of the table,
if you don't want to show many duplicate values.

Or you could try one of the techniques on my web site:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Manos wrote:

Dear all
i have a line chart with two lines, and everything is fine
the problem is that i want to add a 3rd line but for that
line i have only one value that i want it that value to
repeated for 12 times in order to have a total line and
not only the starting point

The issue is that i don't want to add in the excel table
to add 12 columns with the same value.
There is anyway that the chart can repeat the same value?

Thanks in advance
Manos