# Stock Charts with Excel

Stock Charts reflect the price movement of a stock over time. The use of this chart is to predict future stock price movements, which is called expert analysis. Stock market analysts argue that repetition on the chart is inevitable for stock price movements on the graph and this is the basis for reference investors to bring success.

• Step 1: Look at the volume of shares traded as well as the price movement. Identify stocks with increasing prices that have increased trading volume. This shows that the demand for these stocks is rising, and the ability of the stock price will increase. Note, avoid buying stocks that are falling prices but increased trading volume.
• Step 2: Find out how to determine the support price. The price of a stock may fall to a certain level, then increase and then decrease to a certain level previously. We call this a support level because the stock price will not fall below this price. If the stock price drops below the support level, it will likely continue to fall and reach a new low.
• Step 3: Determine the ceiling price of the stock. The ceiling price is the price that the stock is trying to overcome. It is likely to reach this price level and then gradually decline back to the original level. A stock that surpasses its ceiling price is considered a positive sign, which indicates that it will continue to rise.
• Step 4: Study the stock price increase/decrease index. Each day, subtract the number of advancing shares, subtract the amount of promoting stock if the result is a positive number, it means that the increase/decrease index will increase. If the effect continues like this, this is a positive sign and vice versa.
• Step 5: Understand the cycle of votes. Stocks will fluctuate between a support price and a ceiling. Buy the stock when it falls to the support level and start rising, sell the stock when it reaches the ceiling price, and start falling.

## Stock Charts with Excel

• In general, a security table consists of stock insurance dates, stock volumes, opening prices, closing prices, highest and lowest prices.
• In this case, you need to create a Volume-Open-High-Low-Close chart.
• Step 1: Select the data area, click `Insert`> `Other Charts`> `Volume-Open-High-Low-Close`.
• Tips: In Excel 2013, click the Insert arrow> See `All Charts`, in the `Insert Chart` dialog box, select `Stock`> `Volume-Open-High-Low-Close` in the `All Charts` tab, click `OK` to close the dialog box.

=> We have inserted a Stock Chart that includes all stock data into Excel.

• Step 2: In the default chart layout, the data may overlap. To view the chart more conveniently, you can format the Y axis.
• Tips: In Excel 2013, reset the Maximum value in the Format Axis table.
• Step 3: In the Format Axis dialog box, select the Fixed checkbox in the `Maximum` section, type the more significant number in the box until the data is no longer overlapping.
• Step 4: Close the dialog box.
• Tips: There are four types of Stock Charts in Excel, you can create a chart that suits your needs.

## Create a Scatter Chart in Excel with Excel Office Component

• So we have a rough look at the features and uses of the Stock Chart with Excel. Perhaps now you will want to create a Scatter Chart for yourself. However, creating a Stock Chart with Excel on the .NET platform will have a lot of difficulties when it is necessary to use a lot of different knowledge and tools.
• No need to worry anymore cause you now have the full support of the Excel Office Component, making it easier than ever to create charts with Excel.
• We will show you how to create yourself an Excel Stock Chart step-by-step, so please stick with us ;)
• First, please create your own Dataset, which is an original Excel file, and we will proceed to draw a Radar chart based on this amount of data. To do this with the .NET platform, follow these simple steps:
• C# Version:
``````        sheet.Range["B3"].Text = "Precipitation,in.";
sheet.Range["C3"].Text = "Temperature,deg.F";

sheet.Range["A4"].Text = "Jan";
sheet.Range["A5"].Text = "Feb";
sheet.Range["A6"].Text = "March";
sheet.Range["A7"].Text = "Apr";
sheet.Range["A8"].Text = "May";
sheet.Range["A9"].Text = "June";
sheet.Range["A10"].Text = "July";
sheet.Range["A11"].Text = "Aug";
sheet.Range["A12"].Text = "Sept";
sheet.Range["A13"].Text = "Oct";
sheet.Range["A14"].Text = "Nov";
sheet.Range["A15"].Text = "Dec";

sheet.Range["B4"].Number = 10.9;
sheet.Range["B5"].Number = 8.9;
sheet.Range["B6"].Number = 8.6;
sheet.Range["B7"].Number = 4.8;
sheet.Range["B8"].Number = 3.2;
sheet.Range["B9"].Number = 1.4;
sheet.Range["B10"].Number = 0.6;
sheet.Range["B11"].Number = 0.7;
sheet.Range["B12"].Number = 1.7;
sheet.Range["B13"].Number = 5.4;
sheet.Range["B14"].Number = 9.0;
sheet.Range["B15"].Number = 10.4;

sheet.Range["C4"].Number = 47.5;
sheet.Range["C5"].Number = 48.7;
sheet.Range["C6"].Number = 48.9;
sheet.Range["C7"].Number = 50.2;
sheet.Range["C8"].Number = 53.1;
sheet.Range["C9"].Number = 56.3;
sheet.Range["C10"].Number = 58.1;
sheet.Range["C11"].Number = 59.0;
sheet.Range["C12"].Number = 58.5;
sheet.Range["C13"].Number = 55.4;
sheet.Range["C14"].Number = 51.1;
sheet.Range["C15"].Number = 47.8;
sheet.UsedRange.AutofitColumns();

``````
• VB Version:
``````        sheet.Range("B3").Text = "Precipitation,in."
sheet.Range("C3").Text = "Temperature,deg.F"

sheet.Range("A4").Text = "Jan"
sheet.Range("A5").Text = "Feb"
sheet.Range("A6").Text = "March"
sheet.Range("A7").Text = "Apr"
sheet.Range("A8").Text = "May"
sheet.Range("A9").Text = "June"
sheet.Range("A10").Text = "July"
sheet.Range("A11").Text = "Aug"
sheet.Range("A12").Text = "Sept"
sheet.Range("A13").Text = "Oct"
sheet.Range("A14").Text = "Nov"
sheet.Range("A15").Text = "Dec"

sheet.Range("B4").Number = 10.9
sheet.Range("B5").Number = 8.9
sheet.Range("B6").Number = 8.6
sheet.Range("B7").Number = 4.8
sheet.Range("B8").Number = 3.2
sheet.Range("B9").Number = 1.4
sheet.Range("B10").Number = 0.6
sheet.Range("B11").Number = 0.7
sheet.Range("B12").Number = 1.7
sheet.Range("B13").Number = 5.4
sheet.Range("B14").Number = 9.0
sheet.Range("B15").Number = 10.4

sheet.Range("C4").Number = 47.5
sheet.Range("C5").Number = 48.7
sheet.Range("C6").Number = 48.9
sheet.Range("C7").Number = 50.2
sheet.Range("C8").Number = 53.1
sheet.Range("C9").Number = 56.3
sheet.Range("C10").Number = 58.1
sheet.Range("C11").Number = 59.0
sheet.Range("C12").Number = 58.5
sheet.Range("C13").Number = 55.4
sheet.Range("C14").Number = 51.1
sheet.Range("C15").Number = 47.8
sheet.UsedRange.AutofitColumns()
``````
• To create a new Excel file for storing output data - that is, a Scatter Chart, you can use the `WorkbookManager` class in our `Excel Office Component` library.
• C# Version: `WorkbookManager manager = new WorkbookManager();`
• VB Version: `Dim manager As New WorkbookManager()`
• Once you've created a `WorkbookManager`, you can add new workbooks as well as specify the version of the newly created workbook.
• C# Version: `Workbook workbook = manager.Workbooks.Add();`
• VB Version: `Dim workbook As Workbook = manager.Workbooks.Add()`
• Declare a new version
• C# Version: `workbook.Version = SaveAsFormat;`
• VB Version: `workbook.Version = SaveAsFormat`
• You can then create yourself a new `sheet`:
• C# Version: `IWorksheet sheet = workbook.Worksheets;`
• VB Version: `Dim sheet As IWorksheet = workbook.Worksheets(0)`
• After this step, everything is ready; you can now create your chart with the necessary attributes.
• C# Version: `IChart chart = workbook.Charts.Add();`
• VB Version: `Dim sheet As IWorksheet = workbook.Worksheets(0)`
• Declare properties
• C# Version:
``````        IChart chart = workbook.Charts.Add();
chart.ChartTitle = "Radar Chart - Sales by Region";

chart.DataRange = sheet.Range["A3:C15"];
``````
• VB Version:
``````        Dim chart As IChart = workbook.Charts.Add()
chart.ChartTitle = "Radar Chart - Sales by Region"

chart.DataRange = sheet.Range("A3:C15")
``````
• Select chart category and location:
• C# Version:
``````        switch (Type)
{
case 0:
chart.ChartType = ChartType.Stock_HighLowClose;
break;

case 1:
chart.ChartType = ChartType.Stock_OpenHighLowClose;
break;

case 2:
chart.ChartType = ChartType.Stock_VolumeHighLowClose;
break;

case 3:
chart.ChartType = ChartType.Stock_VolumeOpenHighLowClose;
break;

}

chart.IsSeriesInRows = true;
chart.Legend.Position = ExcelLegendPosition.Bottom;
chart.Legend.IsVerticalLegend = false;
``````
• VB Version:
``````      Select Case Type
Case 0
chart.ChartType = ChartType.Stock_HighLowClose

Case 1
chart.ChartType = ChartType.Stock_OpenHighLowClose

Case 2
chart.ChartType = ChartType.Stock_VolumeHighLowClose

Case 3
chart.ChartType = ChartType.Stock_VolumeOpenHighLowClose

End Select

chart.IsSeriesInRows = True
chart.Legend.Position = ExcelLegendPosition.Bottom
chart.Legend.IsVerticalLegend = False
``````
• And with the `Activate()` command, your Radar chart creation is complete.
• C# Version: `chart.Activate();`
• VB Version: `chart.Activate()`

The full source code of this example is also available in our Excel package.

A live demo for Stock Charts is also available on our site. If you also need Excel functionality, check out our Excel online demos.

### 45-Day Money Back Guarantee

#### We will refund your full money in 45 days if you are not satisfied with our products

You have successfully subcribed to our mailing list.
Dont miss out Get update on new articles and other opportunities