Microsoft excel 2007 chart tutorial series#
Instead, it's a donut chart where the pieces in the topmost ring are slightly separated.)Īlthough the donut chart can hold as many series as you want, if you add more than two or three, the chart may appear overly complicated. (An exploded donut doesn't suggest a guilty snack that's met an untimely demise. However, the data on the outside ring tends to become emphasized, so make sure this series is the most important.ĭonuts have two subtypes: standard and exploded. The donut chart's ideal for comparing the breakdown of two different sets of data. The rings are one inside the other, so they all fit into a single compact circle. Each series is contained in a separate ring. But while a pie chart can accommodate only one series of data, the donut can hold as many series as you want. The donut chart is actually an advanced variation on that other classic food-themed chart, the pie chart. Doughnut charts are listed in the Other Charts category. Doughnut chartsĪ doughnut chart is similar to a pie chart, with two exceptions: It has a hole in the middle, and it can display more than one series of data. In this example, we've chosen cells A1 to D2156. Select the range of data for the pivot table and click on the OK button. A Create PivotTable window should appear. In the Tables group, click on the arrow under the PivotTable button and select PivotTable from the popup menu.
You can also use subtypes that have a 3-D effect, or you can create a true 3-D chart that layers the series behind one another. Next, select the Insert tab from the toolbar at the top of the screen. Area charts exist in all the same flavors as line charts, including stacked and 100% stacked.
0 kommentar(er)
