When you pick a type of chart or graph to present your data, you’ll probably consider pie charts, line graphs, and bar charts. Those chart types are used most often because of their familiarity and their straightforward presentation of the relationships between elements of a data series. You can use other types of charts, however, when appropriate. One of those chart types is the stock chart, which you can use to present stock market data.
Create a Stock Chart
Select the stock data you want to chart. Be sure the data is formatted as shown in the figure.
Click the Insert tab.
Click Other Charts.
Click a Stock chart subtype.
Tip
Several stock chart subtypes are available, each of which requires a different set of data columns. When you hover the mouse pointer over a chart subtype, Excel displays information about the subtype and the data it requires.