Plots fluctuations in stock prices or other data.

Uses 3 series of values, in order: high, low, close.

Data needs to be organized in the correct order.

Data Format

• x-axis: Categories (e.g. countries)
  • Categories are spaced evenly along the horizontal axis.
• y-axis: Data Series (e.g. imports as %GDP over time)
  • Series are plotted against the vertical axis.
  • Range of values shown as a line, indicating high and low values over time period.
  • Close value shown as a bar.
  • A data table can be used to display chart values.

High Low Close Category 1 # # # Category 2 # # # Category 3 # # #

Try it now!

• Select a region using the dropdown list to view imports as %GDP over time.
• Close value is data for most recent year that data is available.

• This chart was built using data validation lists, named ranges, conditional statements and the IF, MATCH, OFFSET, RANDARRAY, SEQUENCE, SORTBY and VLOOKUP functions.

Related Waterfall, Funnel, Stock, Surface or Radar Charts

• Funnel
• Radar
• Stock (Open, High, Low, Close)
• Stock (Volume, High, Low, Close)
• Stock (Volume, Open, High, Low, Close)
• Surface
• Waterfall