Continious Point

[Manos]

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

 

[Frank Kabel]

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

Frank

 

[Jon Peltier]

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