So I don't forget: Excel2007.
I've trolled through a dozen on-line examples of creating dynamic charts and have my arms around the situation where there is one Series that could grow or change over time (using dynamic range names via the offset function, plugged into a single series on the graph) -- something like one might find with a Clustered Column chart with just one series in the cluster.
I am trying to create two variables in my chart -- first I want the the X-Axis to expand over time as more weeks pass and more data is gathered. But in addition, I would like to include or exclude an extra series depending on a user selection from a combo box. I have been able to create a dynamic range that grows or contracts depending on the combo box answer, but can't use it to my advantage in the related chart.
Currently, my Stacked Column chart has 5 Series's in it -- I would like to include or exclude a 6th from the source data, depending on the combo box selection. I can't find a tutorial or example of how to do it (everything gives a "simple" example -- I need something less "simple").
Column A includes 5 statuses (call them Status1 through Status5). Row 1 includes a series of dates. Data is currently populated for the first 4 dates. I'd like my chart to have each date on the X axis, with the Stacked Column for the amounts in Status1 through Status5 or Status1 through Status6, depending on the above-mentioned combo box selection.
Confused? Me too. First time poster, so tell me what other info would be helpful to solve this. Explicitly looking to avoid VBA.
I've trolled through a dozen on-line examples of creating dynamic charts and have my arms around the situation where there is one Series that could grow or change over time (using dynamic range names via the offset function, plugged into a single series on the graph) -- something like one might find with a Clustered Column chart with just one series in the cluster.
I am trying to create two variables in my chart -- first I want the the X-Axis to expand over time as more weeks pass and more data is gathered. But in addition, I would like to include or exclude an extra series depending on a user selection from a combo box. I have been able to create a dynamic range that grows or contracts depending on the combo box answer, but can't use it to my advantage in the related chart.
Currently, my Stacked Column chart has 5 Series's in it -- I would like to include or exclude a 6th from the source data, depending on the combo box selection. I can't find a tutorial or example of how to do it (everything gives a "simple" example -- I need something less "simple").
Column A includes 5 statuses (call them Status1 through Status5). Row 1 includes a series of dates. Data is currently populated for the first 4 dates. I'd like my chart to have each date on the X axis, with the Stacked Column for the amounts in Status1 through Status5 or Status1 through Status6, depending on the above-mentioned combo box selection.
Confused? Me too. First time poster, so tell me what other info would be helpful to solve this. Explicitly looking to avoid VBA.
