asked on
Automate excel chart creation
Hello,
I am in need of a script that will automate the creation of a series of scatterplots. The attached Excel file contains three sheets, 1 data sheet and 2 sheets to house the charts:
"GrowInc_AVG" contains the data to be charted. Column A contains the year of data for the x-axis, Columns B to AU contain data to be plotted on the y-axis for one series of charts. Columns AW to CP contain data to be plotted on the y-axis for another series of charts. Each chart should be titled with the field heading.
"CHARTS_1950to2005" contains an example set of charts I made manually that show data from years 1950 to 2005. This is where the remainder of the charts should be written to (rows 49 and 68 should contain the next set of charts for the columns that begin with 7001_2. The remainder of the charts should be written below the previous set with the same spacing to accommodate printing.
"CHARTS_1850to2010" contains an example set of charts I made manually that show data from years 1850 to 2010. These charts are essentially copies of those on "CHARTS_1950to2005" but with a different range of data for both x and y axes.
All charts should include a linear trendline with equation and R-squared shown.
Many thanks in advance. automate-chart-creation.xlsx
I am in need of a script that will automate the creation of a series of scatterplots. The attached Excel file contains three sheets, 1 data sheet and 2 sheets to house the charts:
"GrowInc_AVG" contains the data to be charted. Column A contains the year of data for the x-axis, Columns B to AU contain data to be plotted on the y-axis for one series of charts. Columns AW to CP contain data to be plotted on the y-axis for another series of charts. Each chart should be titled with the field heading.
"CHARTS_1950to2005" contains an example set of charts I made manually that show data from years 1950 to 2005. This is where the remainder of the charts should be written to (rows 49 and 68 should contain the next set of charts for the columns that begin with 7001_2. The remainder of the charts should be written below the previous set with the same spacing to accommodate printing.
"CHARTS_1850to2010" contains an example set of charts I made manually that show data from years 1850 to 2010. These charts are essentially copies of those on "CHARTS_1950to2005" but with a different range of data for both x and y axes.
All charts should include a linear trendline with equation and R-squared shown.
Many thanks in advance. automate-chart-creation.xlsx
Microsoft ExcelVB ScriptProgramming
Last Comment
PrisonBroken