How to create a mixed chart instance _c# tutorial in C # in Excel worksheets

When charting, we might want to present two or more styles of charts in one chart to see different data sizes and trends more clearly and intuitively. In this article, I'll share in C # How to create different chart types in a chart, including how to add a second axis to the same chart.

Here's a simple Excel worksheet where you can see that series 3 data differs from Series 1 and 2 so that we can draw different chart types and different axes to represent changing data:

Code fragment:

Step 1: Create a new object for the workbook class and load the Excel file that you want to create the chart in.

Workbook workbook = new Workbook ();
Workbook. LoadFromFile (@ "E:\Visual studio\sample\book1.xlsx");

Step 2: Get the first worksheet of the workbook.

Worksheet Sheet=workbook. Worksheets[0];

Step 3: Add the chart to the worksheet and set the data A1 to D5 as the data source for the chart.

Chart Chart = sheet. Charts.add ();
Chart. DataRange = sheet. range["A1:d5"];
Chart. Seriesdatafromrange = false;

Step 4: Set the chart position.

Chart. Leftcolumn = 6;
Chart. Toprow = 1;
Chart. Rightcolumn =;
Chart. Bottomrow = 13;

Step 5: Series 1 and 2 use a histogram, Series 3 using a line chart.

var cs1 = (Chartserie) chart. Series[0];
CS1. Serietype = excelcharttype.columnclustered;
var cs2 = (Chartserie) chart. SERIES[1];
CS2. Serietype = excelcharttype.columnclustered;
var cs3 = (Chartserie) chart. SERIES[2];
CS3. Serietype = excelcharttype.linemarkers;

Step 6: Add an axis to the chart and draw the data for Series 3.

Chart. Secondarycategoryaxis.ismaxcross = true;
CS3. Useprimaryaxis = false;

Step 7: Save and run the file.

Workbook. SaveToFile ("result.xlsx");
System.Diagnostics.Process.Start ("result.xlsx");

This is the effect diagram of a mixed chart:

All code:

 workbook workbook = new Workbook (), workbook.
LoadFromFile (@ "E:\Visual studio\sample\book1.xlsx"); Worksheet sheet = workbook.
 
Worksheets[0]; Add a chart to the worksheet and set its data to the data source for the chart Chart Chart = sheet.
Charts.add (); Chart. DataRange = sheet.
range["A1:d5"]; Chart.
 
Seriesdatafromrange = false; Sets the chart position chart.
Leftcolumn = 6; Chart.
Toprow = 1; Chart.
Rightcolumn = 12; Chart.
 
Bottomrow = 13; According to the series use different chart types var cs1 = (Chartserie) chart.
Series[0]; CS1.
Serietype = excelcharttype.columnclustered; var cs2 = (Chartserie) chart.
SERIES[1]; CS2.
Serietype = excelcharttype.columnclustered; var cs3 = (Chartserie) chart.
SERIES[2]; CS3.
 
Serietype = excelcharttype.linemarkers; Add one more axis chart.
Secondarycategoryaxis.ismaxcross = true; CS3.
 
Useprimaryaxis = false; Save and run the file workbook.
SaveToFile ("result.xlsx");
System.Diagnostics.Process.Start ("result.xlsx"); 

  In the above example I use free Spire.xls, the data on the worksheet above you can change according to your requirements, the steps are simpler, you can try to run. I've also written about how to add trend lines, error bars, and other articles in Excel tables, and friends who need them can also refer to them. Thanks for browsing!