How to use Python to Create Financial Chart in Excel

Photo by Towfiqu barbhuiya on Unsplash

Both Python and Excel are useful tools in financial data analysis and visualization. Xlwings, on another hand, offers us the best of both worlds by integrating Python analysis and visualization features with Excel. Xlwings is a Python library that can be used to insert financial data and Matplotlib or Plotly chart in an Excel file.




A publication dedicated to providing concise and practical coding solutions to various problems in finance.

Recommended from Medium

On-Screen Keyboard Becomes Transparent in Windows 10

Enabling MFA Delete on AWS S3 Buckets

On testing 3rd party frameworks without losing your hair 🤯

11 Useful Tips for Getting the Most of Storyline

How to build a RESTful API in Slim 3 — Part 1: Application setup

GitHub — Forking

Seminar Research — Creating Cluster Enviro

Unicode — Hackthebox Walkthrough

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Bee Guan Teo

Bee Guan Teo

Data Scientist. Like problem solving with Python

More from Medium

How to use Python to Generate Stock Report from Excel

Beginner Matplotlib Tutorial with Stylish Lines and Markers

How to get stock price data and draw charts like yahoo finance

How to Set up Your New Computer for Data Science Projects with Python