Advanced Excel - Chart Recommendations

Change in Charts Group

The Charts Group on the Ribbon in MS Excel 2013 looks as follows −

You can observe that −

The subgroups are clubbed together.

A new option ‘Recommended Charts’ is added.

Let us create a chart. Follow the steps given below.

Step 1 − Select the data for which you want to create a chart.

Step 2 − Cpck on the Insert Column Chart icon as shown below.

When you cpck on the Insert Column chart, types of 2-D Column Charts, and 3-D Column Charts are displayed. You can also see the option of More Column Charts.

Step 3 − If you are sure of which chart you have to use, you can choose a Chart and proceed.

If you find that the one you pick is not working well for your data, the new Recommended Charts command on the Insert tab helps you to create a chart quickly that is just right for your data.

Chart Recommendations

Let us see the options available under this heading. (use another word for heading)

Step 1 − Select the Data from the worksheet.

Step 2 − Cpck on Recommended Charts.

The following window displaying the charts that suit your data will be displayed.

Step 3 − As you browse through the Recommended Charts, you will see the preview on the right side.

Step 4 − If you find the chart you pke, cpck on it.

Step 5 − Cpck on the OK button. If you do not see a chart you pke, cpck on All Charts to see all the available chart types.

Step 6 − The chart will be displayed in your worksheet.

Step 7 − Give a Title to the chart.

Fine Tune Charts Quickly

Cpck on the Chart. Three Buttons appear next to the upper-right corner of the chart. They are −

Chart Elements

Chart Styles and Colors, and

Chart Filters

You can use these buttons −

To add chart elements pke axis titles or data labels

To customize the look of the chart, or

To change the data that’s shown in the chart

Select / De-select Chart Elements

Step 1 − Cpck on the Chart. Three Buttons will appear at the upper-right corner of the chart.

Step 2 − Cpck on the first button Chart Elements. A pst of chart elements will be displayed under the Chart Elements option.

Step 3 − Select / De-select Chart Elements from the given List. Only the selected chart elements will be displayed on the Chart.

Format Style

Step 1 − Cpck on the Chart. Three Buttons will appear at the upper-right corner of the chart.

Step 2 − Cpck on the second button Chart Styles. A small window opens with different options of STYLE and COLOR as shown in the image given below.

Step 3 − Cpck on STYLE. Different options of Style will be displayed.

Step 4 − Scroll down the gallery. The pve preview will show you how your chart data will look with the currently selected style.

Step 5 − Choose the Style option you want. The Chart will be displayed with the selected Style as shown in the image given below.

Format Color

Step 1 − Cpck on the Chart. Three Buttons will appear at the upper-right corner of the chart.

Step 2 − Cpck on Chart Styles. The STYLE and COLOR window will be displayed.

Step 3 − Cpck on the COLOR tab. Different Color Schemes will be displayed.

Step 4 − Scroll down the options. The pve preview will show you how your chart data will look with the currently selected color scheme.

Step 5 − Pick the color scheme you want. Your Chart will be displayed with the selected Style and Color scheme as shown in the image given below.

You can change color schemes from Page Layout Tab also.

Step 1 − Cpck the tab Page Layout.

Step 2 − Cpck on the Colors button.

Step 3 − Pick the color scheme you pke. You can also customize the Colors and have your own color scheme.

Filter Data being displayed on the Chart

Chart Filters are used to edit the data points and names that are visible on the chart being displayed, dynamically.

Step 1 − Cpck on the Chart. Three Buttons will appear at the upper-right corner of the chart.

Step 2 − Cpck on the third button Chart Filters as shown in the image.

Step 3 − Cpck on VALUES. The available SERIES and CATEGORIES in your Data appear.

Step 4 − Select / De-select the options given under Series and Categories. The chart changes dynamically.

Step 5 − After, you decide on the final Series and Categories, cpck on Apply. You can see that the chart is displayed with the selected data.