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

--
Message posted from http://www.ExcelForum.com

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/
_______


J. Verdaasdonk < wrote:

> 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 source
> data in an Excel database. This Data is filtered on several criteria
> and has dynamic name ranges to fill the Charts Series Collections and
> so create the specific charts.
>
> Everything works like a charm but I have a lot of Constants of only ONE
> value. (these are Specifications to make the chart readable)
>
> Normally I would fill a column with these values en the have my line
> anyway. But because I have more than 150 constants (in a separate
> sheet) I’ll have to find a way to get the lines occupied with that
> value.
>
> I hope someone understands my Query en has an answer or a good Work
> around.
>
> Thnxx,
> Joost Verdaasdonk
> Ps everything is automation via VBA so I'm looking for a VBA sollution.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>