how do you make a pie chart in excel 2007

To find the percentages, enter the following formula into E2 and copy it down to E5: =C2/B2 Just like column Revenue ( column C), this one represents the progress made in each region, here shown as percentages which will end up being used as data labels further down the road. To find the respective values, type this simple formula into cell D2 and copy it down through cell D5: =B2-C2 This column contains the gross revenue the company has to generate in order to reach the stated goal for each region. The columns are pretty self-explanatory, so let’s get down to the nitty-gritty.īefore we begin, you need to add three additional helper columns and determine the necessary chart data for building the charts.īy the end of this step, your chart data should look like this:įirst, set up column Remainder (column D). With that in mind, consider the following table: In this step-by-step tutorial, you will learn how to create both the progress bar and the progress circle charts in Excel.įor illustration purposes, let’s assume you need to analyze the performance of your international e-commerce business against the stated revenue goals across four major regions: Europe, Asia, Africa, and the Americas. For that reason, don’t forget to check out the Chart Creator Add-in, a versatile tool for creating complex Excel graphs in just a few clicks.īut have no fear. However, these chart types are not supported in Excel, which means that the only way to go is to manually build the charts from scratch. However, all the seemingly endless variety of tricks, techniques, and methods boils down to just two types of progress charts: In Excel, there’s always ten ways to do anything. The chart allows you to monitor and prioritize your objectives, providing critical data for strategic decision-making. Step #5: Adjust the horizontal axis scale.Ī progress chart is a graph that displays the progress made toward a certain goal.

Progress Chart – Free Template Download.Return to Charts Home How to Create Progress Charts (Bar and Circle) in Excel Create, Save, & Use Excel Chart Templates

How do you make a pie chart in excel 2007