If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Variable series multi line chart?
"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! |
Thread Tools | |
Display Modes | |
|
|