- Excel Charts Tutorial
- Excel Charts Useful Resources
- Selected Reading
Most of the parts are repeats with different values and are scattered all over. Can I find low and high value of each. Skip to main content. How to find a low and high value in a range of values. Hi - have a spreadsheet with thousands of part# (Column A) and values (Column B). I have a bar chart that where I need to sort the values from high to low. Obviously, I could sort the source data, but these numbers change monthly and may not always rank in the same order. It's important that the source data stays in the same order once I set it.
Stock charts, as the name indicates are useful to show fluctuations in stock prices. However, these charts are useful to show fluctuations in other data also, such as daily rainfall or annual temperatures.
If you use a Stock chart to display the fluctuation of stock prices, you can also incorporate the trading volume.
For Stock charts, the data needs to be in a specific order. For example, to create a simple high-low-close Stock chart, arrange your data with high, low, and close entered as column headings, in that order.
Follow the steps given below to insert a Stock chart in your worksheet.
Step 1 − Arrange the data in columns or rows on the worksheet.
Step 2 − Select the data.
Step 3 − On the INSERT tab, in the Charts group, click the Stock, Surface or Radar chart icon on the Ribbon.
You will see the different types of available Stock charts.
A Stock chart has the following sub-types −
- High-Low-Close
- Open-High-Low-Close
- Volume-High-Low-Close
- Volume-Open-High-Low-Close
In this chapter, you will understand when each of the Stock chart types is useful.
![Charts Charts](/uploads/1/2/5/8/125867594/988764738.jpg)
High-Low-Close
The High-Low-Close Stock chart is often used to illustrate the stock prices. It requires three series of values in the following order- High, Low, and then Close.
To create this chart, arrange the data in the Order - High, Low, and Close.
You can use the High-Low-Close Stock chart to show the trend of stocks over a period of time.
Open-High-Low-Close
The Open-High-Low-Close Stock chart is also used to illustrate the stock prices. It requires four series of values in the following order: Open, High, Low, and then Close.
To create this chart, arrange the data in the order - Open, High, Low, and Close.
You can use the Open-High-Low-Close Stock chart to show the trend of STOCKS over a period of time.
Volume-High-Low-Close
The Volume-High-Low-Close Stock chart is also used to illustrate the stock prices. It requires four series of values in the following order: Volume, High, Low, and then Close.
To create this chart, arrange the data in the order − Volume, High, Low, and Close.
You can use the Volume-High-Low-Close Stock Chart to show the trend of stocks over a period of time.
![High low chart in excel High low chart in excel](/uploads/1/2/5/8/125867594/654108437.png)
Volume-Open-High-Low-Close
The Volume-Open-High-Low-Close Stock chart is also used to illustrate the stock prices. It requires five series of values in the following order: Volume, Open, High, Low, and then Close.
To create this chart, arrange the data in the order - Volume, Open, High, Low, and Close.
You can use the Volume-Open-High-Low-Close Stock chart to show the trend of stocks over a period of time.