I am trying to set up a script to create vertical stacked bar charts from compiled data but I can’t get it to work, graphs/charts are the bane of my excel life..

The data is in a range 4 columns wide and variable no. of rows, I have been determining the no. of entries by counting up and storing number as variable drlr, I have also set variables for the columns as charts will be made for up to 30 data sets. The first column should contain the horizontal x-axis labels and there will be a separate bar for each row of the table. The series names should be the title line of each column and the data will be in range(501,col2) to (drlr, col4). Each column will have a colour assigned denoting the role in the title line with the legend showing this and the formatting should be consistent across all charts.
If anyone can help with this it would be greatly appreciated, my eyes are falling out and I think I am getting further from the solution the more I try to fix it.