On Sun, 10 Dec 2006 10:00:45 -0500, "Jon Peltier"
wrote:

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.

Thanks again! I have tried google for more information about how Excel
handles this but I haven't found anything that goes in the depth of
it. Do you have any pointers? Sites, books etc.

It seems to me there should be an option to set these settings once
and for all. I have customers making reports with 30-50 different
charts every day and they spend a lot of time tweaking the formatting.
Is VB really the only way to go? Any add-ins you know of? Or do people
use other tools for this sort of work?

--
Fredrik E. Nilsen