Excel 2007 – Create Custom Pie Chart (For Example With Horizontal Data)

1) To Start off, you have a table looking something like this.

2) Goto Ribbon “Insert” – in Charts Bar select “Pie Chart” and choose the pie chart of your choice. We can and will change the layout later.

3) Right click in the empty new chart field and click “select data”

4) In the “Select Data Source” Window click on “Add”

5) In the “Edit Series” Window – “Series Values:” remove “={1}” and select firstly the row with the data you want to report on. Just select the data cells not the tile. (marked with RED in the screenshot)
Afterwards click on the “Series Name” and select the title of the data ie. the title of the graph. (marked with BLUE in the screenshot)
Click OK afterwards.

6) Back to the “Select Data Source” Window click on “Edit” on the right side in the “Horizontal (Category) Axis Label”s Data Source.

7) As “Axis Label Range:” select the row with the names of the Labels you like to select. Dont select the header or row name. Click “OK” afterwards.

8) If you like to pimp up the chart a bit you might like to click on the chart once, then go to the “Design Ribbon” and select in the “Chart Layouts” any other Pie Chart Style” …


.. to get a design similar to this.


%d bloggers like this: