Excel Charts - Fine Tuning

To fine tune the charts quickly, use the three buttons that appear at the upper-right corner of the chart.

The three buttons through which you can fine-tune your chart quickly are −

• Chart Elements − To add chart elements like axis titles or data labels.
• Chart Styles − To customize the look of the chart.
• Chart Filters − To change the data that is shown on the chart.

Step 1 − Click on the chart. Three buttons appear at the upper-right corner of the chart.

Select / Deselect Chart Elements

Step 1 − Click on the chart.

Step 2 − Click Chart Elements. From the list of chart elements, point to each chart element to see how they are displayed on the chart.

Step 3 − Select/deselect chart elements. Only the selected chart elements will be displayed on the chart.

Format Style

You can use Chart Styles to set a style for your chart.

Step 1 − Click on the Chart.

Step 2 − Click the Chart Styles icon. STYLE and COLOR will be displayed. You can use STYLE to fine-tune the look and style of your chart.

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

Step 4 − Scroll down the options. Point at any of the options to see the preview of your chart with the currently selected style.

Step 5 − Choose the style option you want. The chart will be displayed with selected Style.

Format Color

You can use color in chart styles to select the color scheme for your chart.

Step 1 − Click on the Chart.

Step 2 − Click the Chart Styles icon. STYLE and COLOR tabs are displayed.

Step 3 − Click the COLOR tab. Different color scheme options are displayed.

Step 4 − Scroll down the options. Point to any of the options to see the preview of your chart with the currently selected color scheme.

Step 5 − Choose the color option you want. The chart will be displayed with selected color.

Chart Filters

You can use the chart filters to edit the data points (values) and names that are visible on the chart being displayed, dynamically.

Step 1 − Click on the Chart.

Step 2 − Click the Chart Filters icon at the upper-right corner of the chart.

Two tabs – VALUES and NAMES appear in a new window.

Values are the series and the categories in the data.

Step 3 − Click the values. The available series and categories in your data appear.

Step 4 − Select / deselect series and categories. The chart changes dynamically, displaying only the selected series and categories.

Step 5 − After the final selection of series and categories, click Apply. The chart will be displayed with the selected data.