Making improvements to chart generator tool - Easily adding or removing data?

Hello!

I am currently working on my first-ever project using Excel VBA. I am working to create a tool / template that allows my end-users to input data about two items, the item's features, and then show a variety of different cost-comparison charts based on these features.

At the moment, I have a stacked column chart and a Waterfall chart.

I am stuck because I would like to make the tool more easily editable. For example,
- Easily adding new Feature columns for the two bar charts.
- Easily adding new Feature columns for the Waterfall chart.

I have attached the .xlsm that I am working from.

I hope that someone will be able to help me make this template more "living", in the sense that new users can easily adapt it to the data that they need to input.

Thanks for your help!

Originally Posted by dflak

I have a question about how dynamic you need the charts to be. For example, you show 6 features. If the user fills in only 4 of them do you want to show only 4. Or do you want it so the user can insert a 7th feature and show that on the charts as well?

What about adding additional products?

I think this can be done with a combination of Excel Tables and /or named dynamic ranges.

Hi dflak,

Thanks for your response. I would like the chart to be dynamic enough to account for either more or less than 6 Features, as you mentioned. I simply started with six to get me going.

I would also like the ability to add additional product rows.

Do you think that having buttons to add Features and Products would be beneficial? Do you think I should start over, or can this be accomplished with what I have so far?

Originally Posted by dflak

Let me know if you are comfortable with this approach and what else needs to be done.

Hi dflak, thanks so much for your help. This is really close to what I am looking for. I just have a couple more requests/questions about the chart generation:
- What is someone deletes the chart - how can it be regenerated? Are you able to add a button to the spreadsheet that adds the chart?
- Is it possible to add data labels for each Feature as well? Can this be done automatically?

Thanks so much for your help!