Your chart should look like this when you are done: 2) Define a Name with the Offset Formula So highlight the range A3:D7 and insert a pie chart from the Excel Insert Ribbon. Instead, I am going to chart cells A3:D7 so that I exclude the totals since they will not be used in the Pie Chart.

Now I am not going to chart the totals in my pie chart. Setup your spreadsheet data in any fashion that you like as long as you can make a pie chart out of it.

However, I really always stress that users should use Tables as much as possible when creating dynamic Excel Dashboards, but in this instance, I can’t think of a better way than using the Offset function and actually, I can’t think of another way (so if you know of one that doesn’t use VBA or the Offset formula, please let me know in the comments) – (well maybe some combination of the direct formula, but that is the topic for a future post ) The Breakdownġ) Setup Your Data and Create a Pie Chartģ) Edit the Excel Pie Chart and Change the Data Series with Your New Current Data Named Formulaĥ) Link Your Chart Title to the Chart Title CellĦ) Watch in Glee as You Save Yourself Time Every Month Step-by-Step 1) Setup Your Data and Create a Pie Chart Well no problem, we can do this in Excel.

Create pie chart in excel two columns