Create line in chart by filling the serie collection with only 1 value?

[J. Verdaasdonk]

Hi everybody,

Is it possible to create a line in a chart based on ONE value?
(to occupy the Series Collections)

I’m creating an application that created dynamic charts of the sourc
data in an Excel database. This Data is filtered on several criteri
and has dynamic name ranges to fill the Charts Series Collections an
so create the specific charts.

Everything works like a charm but I have a lot of Constants of only ON
value. (these are Specifications to make the chart readable)

Normally I would fill a column with these values en the have my lin
anyway. But because I have more than 150 constants (in a separat
sheet) I’ll have to find a way to get the lines occupied with tha
value.

I hope someone understands my Query en has an answer or a good Wor
around.

Thnxx,
Joost Verdaasdonk
Ps everything is automation via VBA so I'm looking for a VBA sollution

 

[Jon Peltier]

Joost -

Take a look at this web page:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______