From the course: Python in Excel

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Plotting data with matplotlib and seaborn

Plotting data with matplotlib and seaborn

From the course: Python in Excel

Start my 1-month free trial Buy for my team

Plotting data with matplotlib and seaborn

“

- [Instructor] Excel includes many tools for creating charts and graphs. And Python has many very useful plotting tools that are widely used in data science and other fields to generate charts and graphs and other diagrams. Luckily, our Python output is not limited to just text or numbers. Let's take a look at using Pandas with matplotlib as its default plotting backend to draw some basic plots. I'll create a Python cell here and write scores.plot. I'll press Control + Enter. The return value is an image. I'll convert this to an Excel value and there's my chart, but that's pretty small, isn't it? We can either resize the cell it's in or merge that cell with others to make the space bigger but doing that can cause layout problems. So another option we have is to right click this plot, choose Picture and Cell, and then Create Reference. Now we have a nice big version of the plot that floats over the grid and can be…

Contents