You can have up to 255 series in a chart, which should be more than enough
for any legible chart.

In vba you can apply formats to a chart, so this is a matter of setting up
the code to apply the desired formats to the appropriate series.

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


"Fredrik E. Nilsen" wrote in message
...
On Sat, 9 Dec 2006 22:09:05 -0500, "Jon Peltier"
wrote:

Do I have to create a user defined chart with a maximum
number of dataseries and format all series to my specifications?

That's right.


Thanks for your quick reply. A couple of more questions then: What is
the maximum number of dataseries in a chart? And is there a way to
achive consistant formatting through VBA?

--
Fredrik E. Nilsen