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.