Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
course content

Course Content

Excel: the Power of Openpyxl


The openpyxl library in Python provides methods for creating and adding charts to Excel worksheets. Adding charts to Excel data can help you visualize trends, patterns, and relationships in the data, making it easier to understand and analyze. With openpyxl, you can create a variety of charts, such as line charts, bar charts, and pie charts, and customize the appearance and layout of the chart to meet your needs. This functionality allows you to automate the creation of charts based on data in Excel files, saving time and effort compared to manually creating and updating charts in Excel.


  1. Import the Workbook class from openpyxl to create a new Excel workbook.
  2. Import BarChart and Reference from openpyxl.chart to create charts and reference data within Excel sheets.
  3. Initialize a new workbook and select the active sheet to work on.
  4. Define a list of rows containing sample sales data, including headers for "Store", "Sales", and "Revenue", followed by data rows.
  5. Iterate through the list of rows and append each row to the active sheet in the workbook, effectively filling the sheet with your data.
  6. Create a BarChart object to represent the sales and revenue data as a bar chart.
  7. Use the Reference function to specify the range of data on the sheet that will be used for the chart. This includes setting the starting and ending rows (1 to 8) and columns (2 and 3) for the data range.
  8. Add the data to the chart, with an option to use the first row (titles) as data labels.
  9. Place the chart on the sheet at the specified position ("D2").
  10. Save the workbook to a file named "chart.xlsx", which now contains the sales data and the bar chart.

After all, you will reach this result:

Congratulations on completing your project on openpyxl in Python! Your ability to manipulate Excel files programmatically is a valuable skill that will be useful in various industries. Your hard work and dedication to this project are evident, and I'm sure you have learned a lot about working with data in Excel. Your project demonstrates your expertise in openpyxl and will be valuable to your portfolio. Keep up the great work, and I can't wait to see what you will accomplish next!

Mark tasks as Completed

Everything was clear?

Section 1. Chapter 11