VBA - Creating a Dashboard with Charts including data changes

[ChristineVZyl]

Good day.

I trust you are well.

I am new to VBA.
I am struggling so badly.

I need to create a dashboard.
On the dashboard should be chart that uses data from another sheet.
I have a sheet - Dashboard
I have a sheet - Workings

Data I have is:

5 Categories with products

The graph(Line Chart) should have a dynamic y-axis. The way to calculate is that the lower value of the y-axis should be the minimum of the product category selected less ten units and the upper value of the y-axis should be the maximum of the product category selected plus ten units. The y-axis should change when the combo box value is selected.

Will you be able to assist me?
What do you need form me?

Thank you in advance.

 

[Jon Peltier]

You can start by turning on the macro recorder, then manually carrying out the steps you want in your program. The code won't be perfect, but it will be a good starting point.

When you get stuck, you can ask more specific questions here, or try Google (sample query: "Excel vba chart axis scale", be sure to use keywords VBA and Excel).