Product Family

Create Volume-High-Low-Close Stock Charts via C#

Native and high performance MS Excel Charts creation programmatically using server side .NET APIs.

The third stock chart we will look at is the Volume High Low Close chart. Again it is important to repeat that you must have the data in the correct order. If you need to rearrange your data table, you should do it before you set up your chart. This chart include a column for volume immediately after the first (category) column, and the charts include a column chart on the primary axis showing this volume, while the prices are moved to the secondary axis.

How to Create Volume-High-Low-Close Stock Charts via C#

It is easy for the developers to create a Volume-High-Low-Close Stock chart within running different reporting applications for data processing in just a few lines of code.

  1. Include the namespace in your class file
  2. Create Workbook class instance by sample Excel file .
  3. Add a Volume-High-Low-Close Stock Chart to the worksheet by calling the Charts  collection’s Add  method, encapsulated in the Worksheet  object.
  4. Access the new Chart  object from the Charts collection by passing its index.
  5. Set the chart’s data source with Chart.SetChartDataRange method.
  6. Set category data with CategoryData property.
  7. Save as Excel or ODS Output file .

System Requirements

Just make sure that system have Microsoft Windows or a compatible OS with .NET Framework, .NET Core, Windows Azure, Mono or Xamarin Platforms as well as development environment like Microsoft Visual Studio.

- Install from command line as nuget install Aspose.Cells or via Package Manager Console of Visual Studio with Install-Package Aspose.Cells. - Alternatively, get the offline MSI installer or all DLLs in a ZIP file from downloads

Following source code shows how to create a Volume-High-Low-Close Stock Chart to MS Excel XLSX file using C#.