![]() ![]() To select different types of 3-D Pier chart, click on the 'Chart Style' command button and select through different styls. The quickest way to pull all of the slices out of a pie chart is to click the pie chart and then drag away from the center of the chart. To create 3-D Pie chart, select 3-D Pie chart from Insert Chart dropdown (Look at the 1 st picture above). Similarly, to hide any of the months plots on the chart de-select he checkbox and click on Apply. Click the Insert menu and click the small arrow under Pie in the Charts group to see a drop-down menu with icons of available pie chart styles. To plot the Target data on the chart, select 'Target' series radio button and click 'Apply' button. To add filters to the Pie chart, click on the chart and select 'Chart Filters' command button at the top-right of the chart as dislayed in the picture below. ![]() Similarly to change the color scheme, click on the COLOR tab and select different color schemes. Select the chart, click the Chart Tools Design tab, and then click Change Chart Type. For example, to rotate a column chart, you would change it to a bar chart. Scroll through styles and you would see the preview of each styles. If you want to rotate another type of chart, such as a bar or column chart, you simply change the chart type to the style that you want. To add style to this chart, click on the chart and select 'Chart Styles' command button at the top-right corner of the chart as displayed in the picture below. The default is immediate data after the label, in this case it is 'Actual', to know how to show 'Target', read the Chart filter topic below. Notice that Pie chart can only show one type of data (In this case either Actual or Target). You will see a Pie chart appearing on the page as displayed in the picture below. ![]() Go to the INSERT tab in the Ribbon and click on the Pie Chart icon to see the pie chart types. To create 2-D Pie chart in Excel, first select the Chart data and go to INSERT menu and click on 'Insert Pie or Doughnut Chart' command dropdown under Charting group on the ribbon. If you include data labels in your selection, Excel will automatically assign them to each column and generate the chart. In this post, we shall learn how to create Pie chart, add filter and style to it. In last post, we learnt about creating Line chart in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |