How to Create Excel Charts in Vb.Net

Written by samuel porter
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Create Excel Charts in Vb.Net
Chart (chart image by from

Microsoft Excel is a popular spreadsheet program that also creates charts and graphs of all varieties. Part of Microsoft Office, Excel makes viewing and analysing data quick and easy. However, if you need to create a large number of charts, doing so by hand may be time-consuming and error-prone. Instead, consider using Microsoft Visual Basic .NET, Microsoft's new and improved Visual Basic programming language, to automate the task. Its built-in Excel integration makes this a breeze.

Skill level:
Moderately Challenging

Other People Are Reading

Things you need

  • Microsoft Excel (Developer or Professional edition)
  • Microsoft Visual Basic .NET

Show MoreHide


  1. 1

    Open Visual Basic .NET and create a new project.

  2. 2

    Right-click your project and choose Add Reference. Go to the COM tab and click Microsoft Excel Object Library. Click OK.

  3. 3

    Add code in your project's Main function to create a new instance of the Excel application. It should look like this:

    Dim excelApp As New Microsoft.Office.Interop.Excel.Application()

  4. 4

    Add code to create a new spreadsheet. For example:

    Dim wb As Microsoft.Office.Interop.Excel.Workbook = excelApp.Workbooks.Add()

  5. 5

    Add code to retrieve the primary worksheet from the spreadsheet. For example:

    Dim sheet As Microsoft.Office.Interop.Excel.Worksheet = wb.ActiveSheet

  6. 6

    Add data to the spreadsheet. For example, to set the value in the upper-leftmost cell of the spreadsheet (cell A1) to 5, cell A2 to 8, and A3 to 4, write the following code:

    sheet.Cells(1, 1).Value = 5 sheet.Cells(1, 2).Value = 8 sheet.Cells(1, 3).Value = 4

    Do this for all the data you'd like to use in your chart.

  7. 7

    Add code to create the chart:

    Dim chart As Microsoft.Office.Interop.Excel.Chart = sheet.Parent.Charts.Add() chart.ChartWizard(sheet.Range("A1:A3"), Microsoft.Office.Interop.Excel.XlChartType.xl3DColumn, , Excel.XlRowCol.xlColumns)

  8. 8

    Add code to set up the data series for the chart:

    Dim series As Microsoft.Office.Interop.Excel.Series = chart.SeriesCollection(1) series.XValues = sheet.Range("A1", "A3")

  9. 9

    Your chart is now complete. You can customise it further using the functions provided by the Microsoft Developers Network's Office Developer Center at>

Tips and warnings

  • If you need to make your Visual Basic macro more flexible, try replacing some of the strings and numbers in the code with variables. This way, you can use other code in the macro to calculate or look up the values needed for those variables, which means your macro can handle a wider range of possibilities.
  • Always save a backup of your spreadsheet before writing macros. Because the macro functionality is so powerful, it also has the ability to delete or corrupt a lot of data at once. By backing up your spreadsheet, you'll be able to test your macros without fear of losing any work.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.