This video details the VBA code need to create an Excel chart. Get the code here https://www.bluepecantraining.com/vba-to-create-charts-in-excel/

1) How to create a chart object on the same sheet as its data
2) How to create a chart on a chart sheet
3) How to position a chart on a worksheet
4) How to size a chart's width and height
5) How to apply a chart style
6) How to add data labels
7) How to turn gridlines off
8) How to position the chart legend
9) How to axis labels visible/invisible
10) How to axis titles
11) How to set a colour for each series in your chart
12) How to format the background colour of the chart area
------------------------