VBA code to create a chart for every company`s Temperatures

Hello Everybody,
Could your help me in my question ,please?
Please help me to create this vba code because these chart takes me multiple hours to create and update and you will make me save a lot of time.
A brief about the file :
-The file is about a store which contains 2 materials distributed to lots of rooms.We record temperatures for every material in room. And I created a report for every company`s temperatures.
Question:
-I want to create a chart for every company`s Temperatures.
The chart properties:
1-The chart Title Should be Like this : "Company 1(Material 1)" and chart name should be like this "company 1"
2-I need to add a series for each room with the name of the room only ,like this: "2-1"
3-I created a formula to determine the series data and titles on columns F&G
4-The vertical axis should start from 1 not zero
5-The horizontal axis minimum should be taken only from column E "Start Date", and maximum is found on cell "A1".
6-All charts series types are scatter ,limit series is line with red color and width of 2 pt.
7-Legend should be placed in the bottom of the chart.
8-Chart size is 5.28" height and 7.55" width.
see the attachment for an example for the chart.
I really appreciate any help.
Thanks in advance

Ideleted the useless columns and attached the file again
Note:
I need to make chart for every company only Starting from "Start date" in column D .
The end of the chart is the date mentioned in cell A1