Variable series multi line chart?

I have a set of records each having a month/yr value, a product value and a
number field called Backlog that is either 1 or 0. There will always 24
month/yr values represented in my data (24 month range) and there can be at
least 40 different products. The month/yr values will change depending on
what month my report is run, but there could be any number of products.

I want a multi line chart that has the 24 months listed across the bottom
and shows the count of backlog for each product per month (with each product
as a series I guess). I guess my chart data source will have a column for the
month/yr value, and a column for each product showing the backlog count for
each month. I'm dumping my data to a spreadsheet via VBA and I can handle
setting up the data for the chart.

My biggest issue is that there are a variable # of products. How do I set up
my chart to work off of an unknown set of series? Also, Is a limit to the #
of series I can use on a chart?

Thanks!

"Is a limit to the of series I can use on a chart?"

MS documentation states:-

"Data series in one chart 255"

I don't have time at the moment to look at the other issues that you have
raised.

If my comments have helped please hit Yes.

Thanks.


"cherman" wrote:

I have a set of records each having a month/yr value, a product value and a
number field called Backlog that is either 1 or 0. There will always 24
month/yr values represented in my data (24 month range) and there can be at
least 40 different products. The month/yr values will change depending on
what month my report is run, but there could be any number of products.

I want a multi line chart that has the 24 months listed across the bottom
and shows the count of backlog for each product per month (with each product
as a series I guess). I guess my chart data source will have a column for the
month/yr value, and a column for each product showing the backlog count for
each month. I'm dumping my data to a spreadsheet via VBA and I can handle
setting up the data for the chart.

My biggest issue is that there are a variable # of products. How do I set up
my chart to work off of an unknown set of series? Also, Is a limit to the #
of series I can use on a chart?

Thanks!