How to Make a Stock Chart in Excel

Stock Charts are Used to Track Fluctuations in Data

Stock Charts get their name from the Stock Market as they are most often used to track stock prices. However, they can be used to analyze many different types of data such as temperatures, machine output, weight, etc.

Stock Charts in Excel

To create a stock chart in Excel, select your data, then click on the Insert tab, Other Charts and then Stock. There are four different stock charts to choose from.

create a stock chart in Excel

High Low Close

high low close stock chart

Open High Low Close

open high low close stock chart example


Volume High Low Close

volume high low close

Volume Open High Low Close

volume open high low close


Other Charts to Show Data Fluctuation and Variation

Stock charts can be difficult to read, especially those that show the volume on a secondary axis. Here are some other options.

Stock Chart Using Line vs Columns

Right click on one of the columns and change the volume series chart type to line


stock chart with line

Box and Whisker Plot

Similar to the Open High Low Close Stock Chart, the Box Whisker Plot shows Outliers using * and will shade the box to show the median.

box and whisker plot


QI Macros Add-in for Excel Makes it Easy to Create All of These Charts

While its possible to create stock charts in Excel, its extremely complicated and time consuming to create a box and whisker plot. Save yourself time and headaches by using QI Macros. Download a 30 day trial and try it now.

Learn More...

Create these charts and diagrams in just seconds using QI Macros for Excel...
Try It Now!