Home ยป Charts

Volume High Low Close Stock Chart in Excel – Insert, Format, Reading

In the previous blog, we learned the usage of Open High Low Close Chart in Excel. This is the next stock chart type and is quite easy to understand via this blog. Let us move ahead ๐Ÿ˜Ž

What is Volume High Low Close Stock Chart

Stock Charts are basically used to show the stock trends in prices or the number of shares. One such important chart type is Volume High Low Close Stock Chart of Excel visualizing four data series as follows:-

  • Volume :- It is the total number of shares traded in between that period.
  • High Price – It is the maximum price of a stock for a period.
  • Low Price – It is the minimum price that goes for stock in that period.
  • Closing Price – This is the price of last trade for that period.

It is a kind of bar chart with additional functionality.

What do Axes Represent ?

In this stock chart type, we would have one horizontal axis and two vertical axes. In earlier stock chart types we had one vertical axis to represent the data series with different kinds of stock prices. The vertical axis represents:-

  • Primary Vertical – This is the axis at the left of chart and represents the scale for Volume of stock
  • Secondary Vertical – This is the axis at the right of excel chart and represents the prices for stock (high,low,close)
  • Primary Horizontal Axis –The labels represent an increasing time period. It could be seconds, minutes,hours, days, months or years.
Primary and Secondary axis in volume high low close stock chart in excel

Reading a Volume High Low Close Chart in Excel

We need to read the Volume of Stock traded from the Primary Vertical axis while any kind of price is to be read from the Secondary Vertical axis.

reading a volume high low close chart in excel

The arrows in the above figure indicate the axis for reading each data series.

  • Volume – The Arrow in orange reads the volume
  • High Price – The arrow in blue reads High Price
  • Close Price – The arrow in pink reads Close Price
  • Low Price – The arrow in red reads Low Price
infographics volume high low close stock chart in excel

Inserting a Volume High Low Close Chart in Excel

Let us say we have the stock data for a company as follows:-

source data inserting a volume high low close stock chart in excel

To insert a stock chart simply:-

  • Select the range of cells A1:E7
  • Click on Recommended Charts button on the Insert Tab
  • Move to the All Charts tab in the Insert Chart Dialog Box
  • Choose the Stock Charts from the list
  • Select the third chart type fromt there named as Volume High Low Close Chart
inserting a volume high low close stock chart in excel

As a result, this will insert the selected stock chart type with default formatting.

inserting a volume high low close stock chart in excel result

Formatting the Stock Chart

The chart inserted by excel is raw and it needs to be formatted to make it more readable as well as to match it with the theme of your workbook (if any)

Changing the Number Format of Primary Vertical Axis

We can change the Number Format of the axis labels of the Vertical Axis so as to make it short and take up less space on the chart. As you can see that the Primary Vertical Axis Labels have three zeroes at the end of each label we can replace them with a “k” (thousand). To do so:-

  • Click on the Primary Vertical Axis of the chart to select it and then press ctrl + 1
  • This opens the Format Axis Pane for the Primary Vertical Axis
  • Go to the Number Options.
  • Type 0,”k” over “General” and click on Add button
changing the number formats of axis labels int he primary vertical axis

This will format the vertical axis as follows:-

changing the number formats of axis labels int he primary vertical axis result

Formatting Data Series on the Chart

We can format the data series on the chart so as to match it with any existing color scheme. In data series, we can either format the bars (volume) or the vertical line associated with it (prices). To do so:-

  • Select the chart and go to Format tab on the ribbon
  • Go to the Current Selection group and choose “Series Volume”.
  • Click on Format Selection button in the Current Selection Group or press ctrl+1

The Format Data Series Pane must have opened.

changing the fill color of data series of a chart in excel

Choose the solid fill color for the Vertical Bars.

Now Select High – Low Line Options in the Format Pane to format it.

Consequently, you can now change the line color by using the Solid line.

changing the color of vertical lines in volume high low close chart in excel part 2

Choose the color of line to some dark color as we have selected the bar’s color as baby pink. Change the width of these lines to 1.75 pt to make them clearly visible.

The next thing is to add appropriate markers for the Closing Price. All you need to do is select “Series Close” from the Format Pane and then choose the markers type, size, and color.

adding markers to Volume High Low Close stock chart in excel

As a result, we have now beautifully formatted our chart’s data series in a shade of red.

result

And this brings us to the end of the article.

Leave a Comment