Plots fluctuations in stock prices or other data.

Uses 4 series of values, in order: volume, 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. population and life expectancy)
  • Series are plotted against the vertical axis (both primary and secondary where necessary).
  • Range of values shown as a line, indicating high and low values over time period.
  • Close value shown as a bar.
  • Volume shown as a vertical column.

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

Try it now!

• Select a region using the dropdown list to view population and life expectancy ranges.
• Close value is data for most recent year that data is available up to 2018. Population data is for 2018.

• 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 (High, Low, Close)
• Stock (Open, High, Low, Close)
• Stock (Volume, High, Low, Close)
• Surface
• Waterfall