I have a chart with a pair of lines(forecast,actual) for each product in a
group. I am trying to figure out how to format the lines so that: 1) the
actual lines are solid, 2) the forecasts are dashed, and 3) each products
pair of lines has the same color.

I can do this manually for a chart, but I will have a series of these groups
each with a different number of products. Is there a way to set the formats
based on the row(or series name) in the data sheet?

Thanks,

Rich