Point make a pie chart in excel easy to see

It – Hardware & Software | | 3 views

With “the point which makes the pie chart which is easy to know with excelling simply”, it rearranged basic thought in order to draw up the pie chart.From it was refined to finish in the easy to see pie chart where concerning the operation method in order it introduces this article.

It will make the pie chart which is easier to know

In round shape kiyutsu large pie chart.As for the charm at it is not the point which can verify the ratio between “the first” items, probably will be?When of charm in such a pie chart is thought, don’t you think? it stops wanting to collect the information which we would like to verify in the graph on the pie chart.So, by the fact that it does, being easier to see, it is possible to finish in the pie chart which is easy to know.

Here, the last time it drew up using the pie chart “of the number of commodity sale circumstance sales”, draws up, the procedure which a easier to see pie chart is introduced.

The last time it drew up the pie chart “of the number of commodity sale circumstance sales”

Introductory remark is made non indicatory

First, introductory remark is made non indicatory.As for information of the series which is indicated in introductory remark, collecting on the pie chart, the one which it indicates becomes easy to know.In addition, by the fact that introductory remark is made non indicatory, it reaches the point where it can use the graph area widely.To make introductory remark non indicatory, clicking the graph area, it indicates “the graph” tool bar, clicks “the introductory remark” button.

increasing the plot area

the graph area became so widely, by increasing the plot area, let’s large easy-to-read pie chart. to increase the plot area, graph in the toolbar the plot area select the, if you navigate to the upper left portion of the plot area, drag the lower right portion toward the lower right corner.

to change the configuration of the data label

and, information about the series had been displayed in the legend, to display on the pie chart. to do so, you will need to change the configuration of the data label. first, graph series on the toolbar name (here series”product sales situation number of sales” ) select the, formatting of the data series click the button.

graph operation of the toolbar

displayed formatting of the data series of the dialog box data labels tab, contents of the label in classification name check the, to view the leader line if the check is not in check, OK click the button.

formatting of the data series operation of the dialog box

wavy line to the line segment

subsequently, the display of the line segment wavy line set the. by setting this as, make it easier to see with the distinction between data labels and leader lines. how to set, first, graph in the toolbar separatrix1 select the, formatting of the line segment click the button.

graph operation of the toolbar

displayed formatting of the line segment of the dialog box line of style select the wavy line is OK click the button.

formatting of the line segment operation of the dialog box

work so far, pie chart is as follows:.


the format of the data label you want to configure it first

this is the production from. first, the format of the data of the label, font size of the data labels, placement, change the background.

font size, corrected so that the size was the size of the pie chart and balanced, deployment, the set to be displayed in the center of each item. background transparency set to, do not damage the color of the pie chart.

so, let’s set. first, graph in the toolbar, the name of the data label (here “product sales situation number of sales”data labels ) select the, formatting of the data labels click the button.

graph operation of the toolbar

displayed formatting of the data labels of the dialog box font tab, size set the (here 10 set to) , background the transparency set the.

font tab

subsequently, placement of tab position of the label the center set to OK click the button.

placement tab

fine-tune the placement and font color

after you change the formatting of the data label, the placement and adjust the font color to, from here, care must be taken to the operation you want to select the data labels.

to select the data labels, graph select the data label on the toolbar name (label all data will be in selected state) , click the data label you want to select. looking at the pop tip to be displayed when you click, you can see what has hit the mouse on any label data.

if you accidentally click the wrong part of the other, graph select the name of the data labels in the toolbar, reselect the data from all labels, click the data label you want to select.

so, be careful how to select the data labels, let’s carry the work.

current, label all data are located in the center. of this, go to the outside of the pie chart data labels are displayed crowded. to move, select the data labels, click and hold the line that appears enclosed, and then drag it to where you want to move.

in this manner, data labels are displayed crowded, go to all outside. here, desktopPC in addition to, USBmemory a printer other go to the outer.

subsequently, has become difficult to read for a dark color for the series, to change the color of the font of the data labels. first, select the data label you want to change, graph on the toolbar formatting of the data labels click the button.

graph operation of the toolbar

displayed formatting of the data labels of the dialog box font tab, color change the setting of (here pale yellow i tried to set the) .

after this, if you want to change the same color as the color of the label in another data, select the data labels F4 when you press the key, immediately before the operation operation that changes the font color is useful because it is run is repeated.

formatting of the data labels operation of the dialog box

in this manner, adjust the font color of the data difficult to read label. here, digital camera in addition to, mouse keyboard pen tablet to change the color of the font of.

the result of the operation of more than, such as the following easy-to-read pie chart will be completed.

it should be noted, this time, set in the center from the placement of data labels, the data has been moved to the outer label was crowded, this is, procedure is recommended when the data labels that are likely to be less crowded display.

if, if you have a large display data labels that are likely to be crowded, the placement of data labels external has been set to the, it is a good idea to move the data labels do not fit in the center of crowded.


cut out to highlight items

easy-to-read pie chart has been completed at, techniques to emphasize a particular item2let me introduce one.

1second is, cut out the items you want to emphasize is a technique. this method, most quick, will be able to say how stressed and effectively. method of its operation, very easy. select the items you want to cut out, just drag it to the outside.

drag the item you want to cut out


item has been excised

it should be noted, to select a particular item, graph series on the toolbar name (here series”product sales situation number of sales” ) select the select all items, click on the specific item. it is the same as the selection method, such as when you select the data labels.

change the color to highlight items

2second is, is a technique to change the color of the item you want to emphasize. by setting the colors stand out clearly, you can highlight a specific item.

here, notePC let’s highlight items of. select an item, formatting of data elements click the button.

displayed formatting of data elements of the dialog box pattern of tab area in, select the color you want to set OK click the button. here, to emphasize red select the.

item notePC the color of the red was set to. it should be noted, difficult to read because the characters and become a red background, here i tried to change the font color to white.


Additional items from "It – Hardware & Software"