Automate Chart Creation Using Macros in MS Excel

Automate Chart Creation Using Excel Macros (VBA)
Excel 2007	Excel 2003	Macros Excel 2007	Macros Excel 2003	Excel 2010


	A question from a website visitor: I need few examples to create macros in one Excel sheet tab to form graph or chart in next sheet tab of same excel workbook. Could you please help me to achieve same through EXCEL MACROS?Thanks in advance. Chocks Lingam From the developer tab go to the controls group and click on the down arrow of 'insert' and from the Activex controls select a command button. Click and drag to create a command button under the data. Click on the 'Design Mode' in the controls group and then click the command button to select it and finally the 'properties'option in the 'controls' group. Now change the caption of the command button to 'create chart'. Next click on 'view code' also in the controls group of the developer tab and add the following code between the 'sub' and 'end sub' and your final code will look like this: Private Sub CommandButton1_Click() Range("A1:A7,F1:F7").Select ActiveSheet.Shapes.AddChart.Select ActiveChart.SetSourceData Source:=Range( _ "'Sheet1'!$A$1:$A$7,'Sheet1'!$F$1:$F$7") ActiveChart.ChartType = xlColumnClustered ActiveSheet.ChartObjects(1).Activate ActiveSheet.ChartObjects(1).Cut Sheets("Sheet2").Select ActiveSheet.Paste Sheets("Sheet1").Select Range("F9").Activate End Sub The code to decide Grades of the students is given here for reference: =IF(F2>=80,"A",IF(F2>=70,"B",IF(F2>=60,"C",IF(F2>=50,"D","Work Harder")))) Watch the training video below to learn how to automate the creation of charts using macros (VBA) in Microsoft Excel: More Tips (Solutions): How do I view and edit Microsoft Excel files on an iPad? Inventory Soluton How to rename and color worksheet tabs Copy Worksheet Quickly Criteria Range Animations in Microsoft Excel Create two charts at once How to avoid errors while working in Excel How to benefit from Microsoft Excel Templates How to use Microsoft Excel 2007 with Word 2007 - create mail merge labels Landscape Oriented Worksheet Template How to-make a worksheet fit a printed page How to make your charts more impressive Perpetual Calendar from 1900 to 9999 How to create your own custom add-in How to clear conditional formattng in Excel worksheets How to speed up data entry of decimal numbers How to change the color of the gridlines of an Excel worksheet or hide them How to use Autosum in Multiple Worksheet Cells Quickly How to have your free personal assistant in Mcrosoft Excel who reads out the data to you How to use the status bar in Microsoft Excel to do a quick data analysis How to calculate equal monthly payments or instalments using a mathematical equation Data Forms to Enter and Edit Data View 2 worksheets in same workbook side by side Accessing a specific worksheet in large workbooks with multiple worksheets Referencing a cell in another worksheet How to perform a what-if analysis using a scrollbar form control An interesting payroll solution Future Value Solution in Microsoft Excel Another Interesting Conditional Formatting Solution DSUM and Array Formulas for addition solutions IF Function Question How to use command buttons on a splash screen in MS-Excel Copy Paste Data from one Excel Worksheet to Another How to separate comma separated values (csv) in a worksheet cell in Microsoft Excel into rows or columns Another Interesting Solver solution in Microsoft Excel Find duplicates in two different Excel worksheets using a macro How to count data based on multiple criteria - countifs function How to convert 6/5/2011 into Sunday, 6/5/2011 User Form to perform calculations An interesting solution using conditional formatting in Microsoft Excel 2007 Show/Hide Controls on a User-Form using a Checkbox Populate Listbox and Textboxes with Excel data using VBA and Vlookup Protecting Specific Worksheets in an Excel Workbook using VBA How to calculate the difference in hours between two date-time values How do I match data from 2 worksheets and highlight the differences using MS-Excel VBA? How to focus on a specific control (TextBox1) on a user-form in MS-Excel Interesting sumproduct solution COMPARE DATA LISTS USING VLOOKUP AND ISNA FUNCTIONS VLOOKUP SOLUTION USING LIST IN MS EXCEL How to generate random numbers in MS Excel Lottery game in Microsoft Excel Nested If Function to Determine Project Complexity Power Billing Solution in Microsoft Excel Solver Excel - An easy to understand example Another Interest Calculation Solution Interesting Microsoft Excel Formula Based on Date and Row Functions How to subtract dates in Microsoft Excel Automating rounding of decimal numbers in MS-Excel How to Calculate Profit Loss of security transactions in MS Excel How to print comments in Microsoft Excel How to Display Results in a Specific Way in Excel How to Filter or Hide Rows & Display Excel Data in Excel Using A Macro
Quickly find the topic of your interest. Example: Compound Interest.
Excel 2007	Excel 2003	Macros Excel 2007	Macros Excel 2003	Excel 2010

Automate Chart Creation Using Excel Macros (VBA)