Visualize Stock Prices with Excel Candlestick

Published: 15 January 2024
on channel: RBX Excel videos
497
12

In this tutorial, I'll guide you through creating a stunning candlestick chart in Excel. Candlestick charts are essential for visualizing stock market prices throughout the day. You'll learn how to represent opening and closing prices, where green bars indicate price increases and red bars indicate decreases. The extended bars at the top and bottom show the highest and lowest prices of the day.

We'll cover everything you need to get started:

Setting up your data table with dates, opening values, highest values, lowest values, and closing values.
Inserting a candlestick chart in Excel.
Formatting and customizing your chart with titles, color changes, and adjusting the gap width between bars.
Adding a slicer to filter data efficiently by converting your data into a table and tweaking chart settings.

By the end of this video, you’ll be able to create and customize your own professional-looking candlestick charts in Excel. If you find this video helpful, please give it a thumbs up and subscribe to my channel for more Excel tutorials!

Download link for Excel file used in the video: https://drive.google.com/uc?export=do...

0:00 - Intro
1:09 - Inserting the candlestick chart
1:36 - Formatting the candlestick chart
6:49 - Inserting the slicer


Watch video Visualize Stock Prices with Excel Candlestick online without registration, duration hours minute second in high quality. This video was added by user RBX Excel videos 15 January 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 497 once and liked it 12 people.