Excel Charts - Fine Tuning


Advertisements

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 Chart Elements − To add chart elements like axis titles or data labels.
  • Chart Styles and Colors Chart Styles − To customize the look of the chart.
  • Chart Filters 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.

Buttons for Fine Tuning

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.

Select / Deselect Chart Elements

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 and Colors 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.

Format Style

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.

Selected Style Chart

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 and Color Chart Styles icon. STYLE and COLOR tabs are displayed.

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

Format Color

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 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 Chart Filters icon at the upper-right corner of the chart.

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

Values and Names

Values are the series and the categories in the data.

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

Available Series and Categories

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.

Selected Series and Categories
Advertisements