Locked lesson.
About this lesson
In this lesson, we'll discuss how to add 2D and 3D Area Charts to your spreadsheet.
Exercise files
Download this lesson’s related exercise files.
32 - Area Charts - 2D and 3D.docx60.5 KB 32 - Area Charts - 2D and 3D SOLUTION.docx
56.7 KB
Quick reference
Area Charts - 2D and 3D
In this video we'll look at Area Charts in a little more detail.
When to use
Use this whenever you need an Area Chart in your spreadsheet.
Instructions
# Import the charts
from openpyxl.chart import Reference, Series, AreaChart, AreaChart3D
# Create a Chart instance
chart = AreaChart()
To stack more data, you don't need to change any settings, just add your data.
# Remove Legend
chart.legend = None
All the rest of the code is the same from the last couple of videos.
Hints & tips
- chart = AreaChart()
- chart.legend = None
Lesson notes are only available for subscribers.