how to create pie chart in excel 2007 step by step

It highlights that area where your sales have happened (on the world map, you can say). Step 6: You will see a map graph as shown in the image below. Click the OK button once done with editing the data. Excel is smart enough to populate the sales values into series and Country into a category. Step 5: Under Chart Data Range, select the data from cell A1 to cell B6. Step 4: A new pop-up window named “ Select Data Source”. It will allow you to select the data for Map Chart. Step 3: On the Design tab, click on the Select Data option. Step 2: Click on the Maps and select an option called Filled Map. Select Inset, and in chart options, you can see the Maps option there. Step 1: Click anywhere on the table and go to the ribbon placed at the upper pane. Suppose we have data as shown below, which contains our sales values for different countries. Let’s take a simple example of a map chart to just get an overview of how this works in Excel. TEXT and String Functions in Excel (26+).

Lookup and Reference Functions in Excel (36+).

How to create pie chart in excel 2007 step by step