how to create pie chart in excel 2007 step by step

A chart sheet is different from a normal worksheet. You can drag a chart to an open spot on the current sheet or you can put it on a If necessary, create a folder named excelīudget-2010-chart-Lastname-Firstname.xlsx.In the Save As dialog, navigate to where you will be.Click the Office button or the File tab and then on the command Save As.It certainly needs to be in a different place! Your pie chart may use different colors from the illustration and the legend may be in a different location.Ĭhart. The Chart Tools group of tabs shows as long as Click on Insert tab and then on the Pie Chart button.(You may need to scroll to see column N.) Hold CTRL down and select the range N7:N13, the totals for each row.Select the range A7:A13, the row labels in the Inflow section.

To create a chart you first select the data to be charted andĬhart that shows how the Inflow categories compare to the total. This time you will be saving your work as a new file! Create Pie Chart S tart with: budget-2010-Lastname-Firstname.xlsx from previous lesson To format and position data labels - all or single

How to create pie chart in excel 2007 step by step