![]() When you select the data division in the worksheet, click Recommended Charts, the Insert Chart window pops up and you will see the recommended charts provided by Excel for the selected data, which is convenient for users. Surface or Radar Chart : for surface chart, it’s to show trends in values across two dimensions in a continuous curve for radar chart, it’s to show values relative to a center point. ![]() Scatter (X, Y) or Bubble Chart : to show the relationships between sets of values, including scatter charts and bubble charts. ![]() Pie or Doughnut Chart : to show the proportions of a whole, including pie charts and doughnut charts.Combo Chart : to highlight different types of information with mixed types of charts or graphs.Statistic Chart : to show statistic analysis of data, including histograms and box and whisker plots.Line or Area Chart : to show trends over time (year, month and day) or category, including line graphs and area charts.Waterfall or Stock Chart : for waterfall chart, it’s to show cumulative effects of a series of positive and negative values for stock chart, it’s to show the trend of a stock’s performance over time.In the opening Format Data Labels pane, check the Percentage box and uncheck the Value box in the Label Options section. Now the corresponding values are displayed in the pie slices. Hierarchy Chart : to compare parts to a whole or when some columns of categories from a hierarchy, including treemap and sunburst. Select the data you will create a pie chart based on, click Insert > Insert Pie or Doughnut Chart > Pie. ![]()
0 Comments
Leave a Reply. |