From the course: Advanced Python in Excel for Finance: A Hands-On Approach
Join today to access over 24,600 courses taught by industry experts.
Creating financial charts
From the course: Advanced Python in Excel for Finance: A Hands-On Approach
Creating financial charts
- [Instructor] Now, let's dive into how Python in Excel can transform your financial charts. Our journey begins by setting up the Python integration in Excel. This integration allows us to leverage Python's extensive libraries for data visualization directly within Excel's versatile environment. These libraries include the Matplotlib and the Seaborn and Plotly also. Once our environment is set up, we'll start with the basics of financial charting. Through Python, we can customize these charts far beyond Excel's default capabilities, adding dynamic elements that respond to our data's intricacies. We'll look at the line chart and the bar chart. So once you're in Excel, the first thing is usually just to ensure you have your data set right. And just to set up the Python in Excel, just go to Formulas, and once you've activated the Python in Excel, you should see the Insert Python. Once you click on it, you see the Python in Excel, and once I've clicked it, the Python environment is…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.