#Create pie chart in excel with words how to
#Create pie chart in excel with words series

#Create pie chart in excel with words series

Join all the pieces of the pie again, and you will have a fully functional pie chart plotting two series of data on separate axes.

Remember that two slow clicks will highlight an individual piece of the pie. Now, select each slice of pie in turn and drag them back to the center of the pie, producing the chart shown in figure. Pie chart with exploded secondary axisīy exploding the pie, you will not only separate the two axes, revealing the second pie chart, but also compress the pie chart plotted on the secondary axis, allowing you to see both charts. This will create the exploded effect you are looking for, as shown in figure. Select the pie, and while pressing the left mouse button, drag out from the center, then release the left mouse button. The pie chart still looks the same on the surface, but it isn't the same underneath. Pie chart set up from worksheet dataĭouble-click the pie itself again to select it, select Format Data Series, choose the Axis tab, and plot the series on the secondary axis. Select cell D1 for the Name and cells D2:D5 for the Values, then click OK. Next, select the pie chart, right-click it, and select Format » Source Data » Series. When you reach Step 4, make sure you place the chart as an object in the current worksheet. Now work your way through the Chart Wizard, making any changes you need. In Step 1 of the Wizard, under Chart Type, select the first pie chart. Put some data in the range B1:C5, and then select that range and click the Chart Wizard button in the toolbar. To see how this works, first create a basic pie chart. You will be able to edit the graph at any time in the future.It is a bit tricky to see two series of values charted on separate axes within one chart, but the effect is well worth the effort. Once you are happy with the chart's data and appearance, you can delete the table you used to create it. You have the ability to change the placement of the legend, the font used in it, and other items.

Legend: To edit the legend, right-click it and choose “Format Legend”.

You can, for example, modify the scaling, add tick marks, as well as change the font and alignment of the axis labels.

Axis: To customize an axis, right-click it and choose “Format Axis”.

For instance, in a line chart, you can click each line, select “Format Data Series”, and change the line's appearance, including its color and marker. What you can change depends on the type of chart being used.

Data appearance: You can format the appearance of your data in the chart.

However, when you move your cursor to a different cell, both the datasheet and chart are automatically updated. (If do not see the datasheet, right-click a blank area in the graph and select “Datasheet”.) Note that you won't see the data or label as you enter it in the datasheet.

Data and labels: If you want to change the chart's data or labels, click the datasheet and make the changes.

This button makes it easy to experiment so that you can find the best way to present your data. After you select the type, use the “Press and Hold to View Sample” button to preview what the chart will look like based on your actual data.

Chart type: To change the type of chart, right-click a blank area in the graph and choose “Chart Type”.

Next, click the pie chart icon from the charts group of the Insert tab. While in the editing mode, you can change many items, including the: Step 1: Select the entire dataset (A1:B8). If you do not see this border, double-click the chart. You are in this mode when you see a thick border around the chart. To customize the chart, you need to be in the editing mode.

#Create pie chart in excel with words how to

How to Customize the Chartīy default, the table will be converted into a column chart, but you can easily change it to a different type of graph (e.g., line chart, pie chart) as well as format the elements in it (e.g., axis, legend). The chart will be accompanied by a datasheet that contains the data used to create it (i.e., the data in the original table). The resulting chart will be added to your document under the table.

In the “Object types” list, choose “Microsoft Graph Chart”.Click “Object” from the drop-down menu that appears.Click “Object” in the Text group, which is on the right side.