Part 7: Working with Excel cell values, formulas and formatting: C# samples.Part 6: Working with Excel workbooks and worksheets: VB.NET examples.Part 5: Creating custom task panes for Excel 2013 – 2003.Part 4: Customizing Excel main menu, context menus, and Backstage view.Part 3: Customizing Excel ribbons and toolbars.Part 2: Customizing the Excel User Interface: What is and isn't customizable.net:Įxcel Charts add-in (C#) Excel add-in development in Visual Studio for beginners: This sample Excel add-in was developed using Add-in Express for Office and.

Until next time, keep coding! Available downloads: The result of the code above will change the chart to only show information for the selected product: Next, add a custom ribbon tab with a ribbon button, which we’ll use as the trigger to create a chart, using the currently selected range in Excel as the data source.Īdd the following to the Ribbon buttons’ OnClick event: private void insertChartRibbonButton_OnClick ( object sender,Įxcel. I’ve added some sales data from our old friend Northwind Traders to the sheet, which will act as the data source for our chart. Lastly, select Microsoft Excel from the list of supported applications and finish the New Microsoft Office COM Add-in wizard.įirstly, we need to have some data in order to create a chart. We’ll choose Office 2013 for this example, as there has been a few changes to the object model I’d like to show you. When prompted select your programming language (C#, VB.NET or C++.NET) and the Minimum Office version you would like to support.

You will find the project template under Other Project Types > Extensibility. Let’s start by creating a new ADX COM Add-in project using Add-in Express for Office and. In this article we’ll take a look at how to insert charts programmatically, format their style and colors as well as how to change the chart’s display by filtering its data. When it comes to visualizing data nothing beats charts and there are only few applications that tie data and charts so well together as Microsoft Excel.Īdding charts in your Excel add-ins using the Excel object model is easier than you might think.

Chart add ins for excel 2013