Create a Column Chart with a Macro in Excel
This macro adds a column chart to Excel. This is an easy to use macro that allows you to quickly chart and graph a range of data in Excel. This is a small macro that will create the column chart from a range or set of data that you have in your worksheet. The ranges are hard-coded into the macro.
To use this macro, you only need to replace 'Sheet1'!$A$1:$B$67 with the range or cell references that contain your source data in Excel.
Where to install the macro: Module
Excel Macro to Create a Column Chart
Sub Create_Column_Chart()
'create a column chart with this excel macro
ActiveSheet.Shapes.AddChart.Select
ActiveChart.SetSourceData Source:=Range("'Sheet1'!$A$1:$B$67")
ActiveChart.ChartType = xlColumnClustered
End Sub
Subscribe for Weekly Tutorials
Helpful tutorials delivered to your email!
Similar Content on TeachExcel
Create a Bar Chart With a Macro in Excel
Macro: Create a bar chart in Excel with this macro. You will be able to quickly and easily turn a...
Macro: Create a bar chart in Excel with this macro. You will be able to quickly and easily turn a...
Create a Line Chart with a Macro in Excel
Macro: Create a line chart in Excel with this macro. This allows you to quickly and easily create...
Macro: Create a line chart in Excel with this macro. This allows you to quickly and easily create...
Automatically Run a Macro so Many Seconds, Minutes, or Hours After an Excel Workbook has been Opened
Macro: Run a macro after a certain amount of time has passed since the Excel workbook was ope...
Macro: Run a macro after a certain amount of time has passed since the Excel workbook was ope...
Creating a Splash Screen in Excel
Tutorial: Create a pop-up window, splash screen, that appears when Excel starts. This allows you to ...
Tutorial: Create a pop-up window, splash screen, that appears when Excel starts. This allows you to ...
Pass Arguments to a Macro Called from a Button or Sheet in Excel
Tutorial: How to pass arguments and values to macros called from worksheets, buttons, and anything e...
Tutorial: How to pass arguments and values to macros called from worksheets, buttons, and anything e...
Delete Duplicate Values in All Versions of Excel
Tutorial: How to delete duplicate values from a data set in all versions of Excel. This includes Ex...
Tutorial: How to delete duplicate values from a data set in all versions of Excel. This includes Ex...
How to Install the Macro
- Select and copy the text from within the grey box above.
- Open the Microsoft Excel file in which you would like the Macro to function.
- Press "Alt + F11" - This will open the Visual Basic Editor - Works for all Excel Versions.
Or For other ways to get there, Click Here.
- On the new window that opens up, go to the left side where the vertical pane is located. Locate your Excel file; it will be called VBAProject (YOUR FILE'S NAME HERE) and click this.
- If the Macro goes in a Module, Click Here, otherwise continue to Step 8.
- If the Macro goes in the Workbook or ThisWorkbook, Click Here, otherwise continue to Step 8.
- If the Macro goes in the Worksheet Code, Click Here, otherwise continue to Step 8.
- Close the Microsoft Visual Basic Editor window and save the Excel file. When you close the Visual Basic Editor window, the regular Excel window will not close.
- You are now ready to run the macro.