- Excel Charts Tutorial
- Excel Charts - Home
- Excel Charts - Introduction
- Excel Charts - Creating Charts
- Excel Charts - Types
- Excel Charts - Column Chart
- Excel Charts - Line Chart
- Excel Charts - Pie Chart
- Excel Charts - Doughnut Chart
- Excel Charts - Bar Chart
- Excel Charts - Area Chart
- Excel Charts - Scatter (X Y) Chart
- Excel Charts - Bubble Chart
- Excel Charts - Stock Chart
- Excel Charts - Surface Chart
- Excel Charts - Radar Chart
- Excel Charts - Combo Chart
- Excel Charts - Chart Elements
- Excel Charts - Chart Styles
- Excel Charts - Chart Filters
- Excel Charts - Fine Tuning
- Excel Charts - Design Tools
- Excel Charts - Quick Formatting
- Excel Charts - Aesthetic Data Labels
- Excel Charts - Format Tools
- Excel Charts - Sparklines
- Excel Charts - PivotCharts
- Excel Charts Useful Resources
- Excel Charts - Quick Guide
- Excel Charts - Useful Resources
- Excel Charts - Discussion
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.
To Continue Learning Please Login
Login with Google