Candlestick charts

Data Visualization in Google Sheets

Raina Hawley

Owner/Instructor - OzGrid Business Applications

Creating a candlestick

  • Display price information
    • Show trends
    • Predict future behavior
    • Display day to day market movement
  • Optimize your dataset first
    • Named ranges
    • Validations
    • VLOOKUPs
Data Visualization in Google Sheets

Formatting dates as plain text

Data Visualization in Google Sheets

Plain text using a formula

Data Visualization in Google Sheets

Viewing the detail

Data Visualization in Google Sheets

Formatting your candlestick chart

Data Visualization in Google Sheets

Let's do it!

Data Visualization in Google Sheets

Preparing Video For Download...