In this tutorial we learn that how to create&format pie chart in excel. MS Excel provide the facility to create pie chart and format it. By 2D pie cart representation of data is graphical. Readability of data increases by using pie chart. For creating the chart first select the data for which you want to create chart. After selection of data click on insert menu and select the pie chart. For format chart use the format option and design option.
create&format pie chart in excel example:-
We want to create the chart&format chart in excel. We have data of soap sales per month. Select the all data like soap name and sales per month.
For add chart into the sheet click on the insert menu and select pie chart.
After selection of the pie chart sheet is become as following.
For changing the design of the pie chart click on design menu and select the required design.
After changing the design of chart. Chart become as following.
We also change the layout of the pie chart by using the Quick Layout option in design menu.
After changing the layout of chart to layout 4 chart become as following.
You also can change the colors of pie chart by using the option change colors.
After selection of colors chart become as.
Now for inserting title to the chart use option add element to chart.
By default now chart title is none so no title show. If select above chart the title is show above the chart.
For format pie chart select pie chart and by using the format menu you can format the chart.
By using format menu you can change the background color of the chart also change the border of chart. change background color by using the shape fill option.
After changing color of background to blue accent 1 chart become as following.
Also change the effect of chart by using option shape effect.
After changing the shape effect the chart become as following.
Please follow and like us: