- Excel Charts - PivotCharts
- Excel Charts - Sparklines
- Excel Charts - Format Tools
- Excel Charts - Aesthetic Data Labels
- Excel Charts - Quick Formatting
- Excel Charts - Design Tools
- Excel Charts - Fine Tuning
- Excel Charts - Chart Filters
- Excel Charts - Chart Styles
- Excel Charts - Chart Elements
- Excel Charts - Combo Chart
- Excel Charts - Radar Chart
- Excel Charts - Surface Chart
- Excel Charts - Stock Chart
- Excel Charts - Bubble Chart
- Excel Charts - Scatter (X Y) Chart
- Excel Charts - Area Chart
- Excel Charts - Bar Chart
- Excel Charts - Doughnut Chart
- Excel Charts - Pie Chart
- Excel Charts - Line Chart
- Excel Charts - Column Chart
- Excel Charts - Types
- Excel Charts - Creating Charts
- Excel Charts - Introduction
- Excel Charts - Home
Excel Charts Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
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 pke 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 − Cpck on the chart. Three buttons appear at the upper-right corner of the chart.

Select / Deselect Chart Elements
Step 1 − Cpck on the chart.
Step 2 − Cpck Chart Elements. From the pst 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 − Cpck on the Chart.
Step 2 − Cpck 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 − Cpck 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 − Cpck on the Chart.
Step 2 − Cpck the Chart Styles icon. STYLE and COLOR tabs are displayed.
Step 3 − Cpck 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 − Cpck on the Chart.
Step 2 − Cpck 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 − Cpck 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, cpck Apply. The chart will be displayed with the selected data.
