Excel Charts Tutorial

Discuss Excel Charts

Discuss Excel Charts &-8211; this Article or News was published on this date:2019-05-13 18:12:10 kindly share it with friends if you find it helpful

Discuss Excel Charts


Advertisements


A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends much easier. In this tutorial, you will learn how to insert charts and modify them so they communicate information effectively. Each of Excel&-8217;s 12 chart types has different features that make them better suited for specific tasks. Pairing a chart with its correct data style will make the information easier to understand, enhancing the communication within your small business.




Advertisements

Excel Charts &-8211; Home

Excel Charts &-8211; Introduction

Excel Charts &-8211; Creating Charts

Excel Charts &-8211; Types

Excel Charts &-8211; Column Chart

Excel Charts &-8211; Line Chart

Excel Charts &-8211; Pie Chart

Excel Charts &-8211; Doughnut Chart

Excel Charts &-8211; Bar Chart

Excel Charts &-8211; Area Chart

Excel Charts &-8211; Scatter (X Y) Chart

Excel Charts &-8211; Bubble Chart

Excel Charts &-8211; Stock Chart

Excel Charts &-8211; Surface Chart

Excel Charts &-8211; Radar Chart

Excel Charts &-8211; Combo Chart

Excel Charts &-8211; Chart Elements

Excel Charts &-8211; Chart Styles

Excel Charts &-8211; Chart Filters

Excel Charts &-8211; Fine Tuning

Excel Charts &-8211; Design Tools

Excel Charts &-8211; Quick Formatting

Excel Charts &-8211; Aesthetic Data Labels

Excel Charts &-8211; Format Tools

Excel Charts &-8211; Sparklines

Excel Charts &-8211; PivotCharts

Excel Charts &-8211; Quick Guide

Excel Charts &-8211; Useful Resources

Excel Charts &-8211; Discussion

UPSC IAS Exams Notes

Developer&-8217;s Best Practices

Questions and Answers

Effective Resume Writing

HR Interview Questions

Computer Glossary

Who is Who

Excel Charts – Useful Resources

Excel Charts &-8211; Useful Resources &-8211; this Article or News was published on this date:2019-05-13 18:12:08 kindly share it with friends if you find it helpful

Excel Charts &-8211; Useful Resources


Advertisements


The following resources contain additional information on Excel Charts. Please use them to get more in-depth knowledge on this.

Useful Links on Excel Charts

Useful Books on Excel Charts

  • EXCEL: Master Excel: Sharing Your Work, Charts and Graphing
  • Excel 2016 For Dummies
  • Mastering Excel: Charts
  • Excel Charts
  • Excel 2013 Charts and Graphs
  • Excel Dashboards and Reports For Dummies

To enlist your site on this page, please drop an email to [email protected]



Advertisements

Excel Charts &-8211; Home

Excel Charts &-8211; Introduction

Excel Charts &-8211; Creating Charts

Excel Charts &-8211; Types

Excel Charts &-8211; Column Chart

Excel Charts &-8211; Line Chart

Excel Charts &-8211; Pie Chart

Excel Charts &-8211; Doughnut Chart

Excel Charts &-8211; Bar Chart

Excel Charts &-8211; Area Chart

Excel Charts &-8211; Scatter (X Y) Chart

Excel Charts &-8211; Bubble Chart

Excel Charts &-8211; Stock Chart

Excel Charts &-8211; Surface Chart

Excel Charts &-8211; Radar Chart

Excel Charts &-8211; Combo Chart

Excel Charts &-8211; Chart Elements

Excel Charts &-8211; Chart Styles

Excel Charts &-8211; Chart Filters

Excel Charts &-8211; Fine Tuning

Excel Charts &-8211; Design Tools

Excel Charts &-8211; Quick Formatting

Excel Charts &-8211; Aesthetic Data Labels

Excel Charts &-8211; Format Tools

Excel Charts &-8211; Sparklines

Excel Charts &-8211; PivotCharts

Excel Charts &-8211; Quick Guide

Excel Charts &-8211; Useful Resources

Excel Charts &-8211; Discussion

UPSC IAS Exams Notes

Developer&-8217;s Best Practices

Questions and Answers

Effective Resume Writing

HR Interview Questions

Computer Glossary

Who is Who

Excel Charts – PivotCharts

Excel Charts &-8211; PivotCharts &-8211; this Article or News was published on this date:2019-05-13 18:11:37 kindly share it with friends if you find it helpful

Excel Charts &-8211; PivotCharts


Advertisements


Pivot charts are used to graphically summarize the data and explore complicated data.

A Pivot chart shows the data series, categories, and chart axes the same way a standard chart does. Additionally, it also gives you interactive filtering controls right on the chart so that you can quickly analyze a subset of your data.

Pivot charts are useful when you have the data in a huge Pivot table or a lot of complex worksheet data that includes text and numbers. A Pivot chart can help you make sense of this data.

You can create a Pivot chart in the following ways −

  • From a Pivot table

  • From a data table as a standalone without Pivot table

  • From a data table as a standalone without Pivot table with recommended charts

Creating a PivotChart from a PivotTable

To create a Pivot chart from a Pivot table −

Step 1 − Click the Pivot table. The Ribbon shows the Pivot table tools – ANALYZE and DESIGN on the Ribbon.

Creating a PivotChart

Step 2 − Click the ANALYZE tab. The Ribbon converts to the options available in ANALYZE tab.

Step 3 − Click PivotChart. An Insert Chart window appears.

ANALYZE tab

Step 4 − Click Column and then Clustered Column. Click OK. You can see the Pivot chart.

Clustered Columns

To summarize the data as you want, you can click any interactive control and then pick the sort or filtering options you want.

Step 5 − Click Region Filter Control. A search box appears with the list of all the regions.

Step 6 − Click Select Multiple Items. Check Boxes appear for the list of all the regions.

Step 7 − Select the East and South check boxes. Click OK.

East and South check boxes

Step 8 − Click the Chart Elements Chart Elements icon.

Step 9 − Click Bottom from the options under the Legend option.

Step 10 − Now click the Month Filter control and select January. Click OK.

Month Filter

The Pivot chart is displayed with the filtered data.

Pivot Chart Displayed

As in the case of normal charts, you can use the chart elements and the chart filters that appear at the right-top corner of the pivot chart to format the pivot chart to make it more presentable.

You have already seen how we changed the position of legend in the above given steps. Now, we will use chart styles to make the Pivot chart much more presentable.

Step 1 − Click the Chart Styles icon.

Step 2 − Under the STYLE option, choose Style 2.

Style Option

Style 2 has data labels above the columns that makes the Pivot chart more readable.

Style2

Creating a PivotChart from the Data Table as a Standalone PivotChart

You can create a Pivot chart without creating a Pivot table first.

Step 1 − Select the data table.

Step 2 − On the Insert tab, in the Charts group, click PivotChart on the Ribbon.

A Create PivotChart window appears.

Step 3 − Select the Table/Range

Step 4 − Select the location where you want the Pivot chart to be placed. You can choose a cell on the existing worksheet itself or on a new worksheet. Click OK.

Standalone PivotChart

An empty Pivot chart and an empty Pivot table appear along with the Pivot chart field list to build the Pivot chart.

Empty PivotChart

Step 5 − Choose the fields to be added to the Pivot chart.

Step 6 − Arrange the fields by dragging them into FILTERS, LEGEND (SERIES), AXIS (CATEGORIES) and VALUES.

Step 7 − Use the Filter Controls on the Pivot chart to select the data to be placed on the Pivot chart. Excel will automatically create a coupled Pivot table.

PivotTable

Recommended Pivot Charts

You can create a Pivot chart that is recommended for your data without first creating a Pivot table. Just as in the case of normal charts, Excel provides Recommended Pivot charts so that to quickly decide on the type of PivotChart that suits your data.

Step 1 − Select the data table.

Step 2 − On the Insert tab, in the Charts group, click Recommended Charts.

Recommended Pivot Charts

An Insert Chart window appears with two tabs Recommended charts and All charts.

Step 3 − Click the Recommended Charts tab.

Charts with the PivotChart icon PivotChart icon in the top right corner are Pivot charts.

Recommended Charts Tab

Step 4 − Click a Pivot chart. The preview appears on the right side.

Preview of PivotChart

Step 5 − Click OK once you find the Pivot chart you want.

Your standalone Pivot chart for your data is displayed. Excel will automatically create a coupled Pivot table.

Couple PivotTable



Advertisements

Excel Charts &-8211; Home

Excel Charts &-8211; Introduction

Excel Charts &-8211; Creating Charts

Excel Charts &-8211; Types

Excel Charts &-8211; Column Chart

Excel Charts &-8211; Line Chart

Excel Charts &-8211; Pie Chart

Excel Charts &-8211; Doughnut Chart

Excel Charts &-8211; Bar Chart

Excel Charts &-8211; Area Chart

Excel Charts &-8211; Scatter (X Y) Chart

Excel Charts &-8211; Bubble Chart

Excel Charts &-8211; Stock Chart

Excel Charts &-8211; Surface Chart

Excel Charts &-8211; Radar Chart

Excel Charts &-8211; Combo Chart

Excel Charts &-8211; Chart Elements

Excel Charts &-8211; Chart Styles

Excel Charts &-8211; Chart Filters

Excel Charts &-8211; Fine Tuning

Excel Charts &-8211; Design Tools

Excel Charts &-8211; Quick Formatting

Excel Charts &-8211; Aesthetic Data Labels

Excel Charts &-8211; Format Tools

Excel Charts &-8211; Sparklines

Excel Charts &-8211; PivotCharts

Excel Charts &-8211; Quick Guide

Excel Charts &-8211; Useful Resources

Excel Charts &-8211; Discussion

UPSC IAS Exams Notes

Developer&-8217;s Best Practices

Questions and Answers

Effective Resume Writing

HR Interview Questions

Computer Glossary

Who is Who

Excel Charts – Sparklines

Excel Charts &-8211; Sparklines &-8211; this Article or News was published on this date:2019-05-13 18:11:34 kindly share it with friends if you find it helpful

Excel Charts &-8211; Sparklines


Advertisements


Sparklines are tiny charts placed in single cells, each representing a row of data in your selection. They provide a quick way to see trends.

Sparklines have the following types −

  • Line Sparkline
  • Column Sparkline
  • Win/Loss Sparkline

In this chapter, you will understand the different types of Sparklines and the way to add them to your data. You can add Sparklines through the Quick Analysis tool or through the INSERT tab on the Ribbon.

Sparklines with Quick Analysis

With Quick Analysis Tool, you can show the Sparklines alongside your data in the Excel data table.

Follow the steps given below.

Step 1 − Select the data for which you want to add Sparklines. Keep an empty column to the right side of the data for the Sparklines.

Sparklines with Quick Analysis

The Quick Analysis icon Quick Analysis Button appears at the bottom right of your selected data.

Quick Analysis

Step 2 − Click the Quick Analysis Quick Analysis Button button that appears (or press CRTL+Q). The Quick Analysis Toolbar appears with the following options

  • FORMATTING
  • CHARTS
  • TOTALS
  • TABLES
  • SPARKLINES

Quick Analysis Toolbar

Step 3 − Click SPARKLINES. The chart options displayed are based on the data and may vary.

Sparklines

Line Sparkline – with Quick Analysis Toolbar

Step 4 − Click the Line button. A line chart for each row is displayed.

Sparklines Line Chart

Column Sparkline – with Quick Analysis Toolbar

Step 5 − Click the Column button. A column chart for each row is displayed.

Column Sparkline

Win/Loss Sparkline – with Quick Analysis Toolbar

Step 6 − Click the Win/Loss button. A win/loss chart for each row is displayed.

Win/Loss Sparkline

Sparklines with INSERT tab

When you add Sparklines with INSERT tab on the Ribbon, you can show the Sparklines either alongside your data in the Excel data table as you had seen with Quick Analysis tool or in any location that you can choose on the worksheet.

Follow the steps given to add Sparklines through the Insert tab.

Step 1 − Click the INSERT tab on the Ribbon. The Sparklines group appears on the Ribbon, with three tabs −

  • Line
  • Column
  • Win/Loss

Sparklines with INSERT tab

Line Sparkline through INSERT tab on Ribbon

Step 2 − Click the Line option. A Create Sparklines window appears. It will have placeholders for the data range and the location range.

Step 3 − Select Data Range or type the data range in the box.

Line Sparkline

Step 4 − Select the Location range where you want the Sparklines to be placed.

Location Range

Step 5 − Click OK.

A line chart for each row of the selected data is displayed at the selected location.

Sparkline Line Charts

Column Sparkline – with INSERT tab on Ribbon

Step 1 − Click the INSERT tab on the Ribbon.

Step 2 − Click the Column button in the Sparklines group on the Ribbon.

Column Sparkline with INSERT tab

A Create Sparklines window appears, with placeholders for data range and location range.

Step 3 − Select the data range.

Data Range

Step 4 − Select the location range where you want the Sparklines to be placed.

Sparklines Placing

Step 5 − Click OK.

A column chart for each row of the selected data is displayed at the selected location.

Selected Location

Win/Loss Sparkline – with INSERT tab on Ribbon

Step 1 − Click the INSERT tab on the Ribbon.

Step 2 − Click the Win/Loss button in the Sparklines group on the Ribbon.

Win/Loss Sparkline with INSERT tab

A Create Sparklines window appears, with placeholders for data range and location range.

Step 3 − Select the data range.

Select Data Range

Step 4 − Select the Location Range where you want the Sparklines to be placed.

Select Location Range

Step 5 − Click OK.

A Win/Loss chart for each row of the selected data is displayed at the selected location.

Win/Loss Chart



Advertisements

Excel Charts &-8211; Home

Excel Charts &-8211; Introduction

Excel Charts &-8211; Creating Charts

Excel Charts &-8211; Types

Excel Charts &-8211; Column Chart

Excel Charts &-8211; Line Chart

Excel Charts &-8211; Pie Chart

Excel Charts &-8211; Doughnut Chart

Excel Charts &-8211; Bar Chart

Excel Charts &-8211; Area Chart

Excel Charts &-8211; Scatter (X Y) Chart

Excel Charts &-8211; Bubble Chart

Excel Charts &-8211; Stock Chart

Excel Charts &-8211; Surface Chart

Excel Charts &-8211; Radar Chart

Excel Charts &-8211; Combo Chart

Excel Charts &-8211; Chart Elements

Excel Charts &-8211; Chart Styles

Excel Charts &-8211; Chart Filters

Excel Charts &-8211; Fine Tuning

Excel Charts &-8211; Design Tools

Excel Charts &-8211; Quick Formatting

Excel Charts &-8211; Aesthetic Data Labels

Excel Charts &-8211; Format Tools

Excel Charts &-8211; Sparklines

Excel Charts &-8211; PivotCharts

Excel Charts &-8211; Quick Guide

Excel Charts &-8211; Useful Resources

Excel Charts &-8211; Discussion

UPSC IAS Exams Notes

Developer&-8217;s Best Practices

Questions and Answers

Effective Resume Writing

HR Interview Questions

Computer Glossary

Who is Who

Excel Charts – Format Tools

Excel Charts &-8211; Format Tools &-8211; this Article or News was published on this date:2019-05-13 18:11:32 kindly share it with friends if you find it helpful

Excel Charts &-8211; Format Tools


Advertisements


The CHART TOOLS menu comprises of two tabs DESIGN and FORMAT.

When you click on a chart, a new tab CHART TOOLS comprising of DESIGN and FORMAT tabs appear on the Ribbon.

CHAR TOOLS

Click the FORMAT tab on the Ribbon. The Ribbon changes to the FORMAT commands.

FORMAT Tab

The Ribbon contains the following format commands −

  • Current Selection Group

    • Chart Element Selection Box

    • Format Selection

    • Reset to Match Style

  • Insert Shapes Group

    • Different Shapes to Insert

    • Change Shape

  • Shape Styles Group

    • Shape Styles

    • Shape Fill

    • Shape Outline

    • Shape Effects

  • WordArt Styles

    • WordArt Styles

    • Text Fill

    • Text Outline

    • Text Effects

  • Arrange Group

    • Bring Forward

    • Send Backward

    • Selection Pane

    • Align

    • Group

    • Rotate

  • Size Group

    • Shape Height

    • Shape Width

Current Selection Group

You can format chart elements using the Current Selection Group commands.

For formatting your charts through the Ribbon, follow the given steps.

Step 1 − Select the chart element you want to format. It appears in the box provided at the top of the group.

Step 2 − Click Format Selection. The Format pane appears for the selected chart element.

Step 3 − Format the selected chart element using the options in the format pane.

Current Selection Group

Refer chapter − Formatting Charts Quickly in this Tutorial.

Insert Shapes Group

You can insert different shapes in your chart selecting the shapes. After you insert a shape, you can add text to it, with Edit Text.

You can edit shape with −

  • Change Shape
  • Edit Points

Insert Shape Group

Shape Styles Group

You can change the style of the shape, choosing the given styles −

  • You can choose a Shape Fill Color.
  • You can Format Shape Outline.
  • You can add Visual Effects to the Shape.

Shape Styles Group

WordArt Styles Group

You can use the word art to change the way your chart is displayed. The available options are −

  • Fill the text with a color with the Text Fill command.

  • Customize the Text Outline.

  • Add visual effects to the text with Text Effects.

Wordarts Styles Group

Arrange Group

The Arrange Group commands are used to select the objects on your chart, change the order or visibility of the selected objects.

To see the objects that are present on your chart, click the selection pane command. The selection pane appears listing the objects available on your chart.

Arrage Group

Select the objects and then you can do the following with the selected objects −

  • Bring Forward
  • Send Backward
  • Selection Pane
  • Align
  • Group
  • Rotate

Size Group

The Size Group commands are used to change the width or the height of the shape or picture on the chart. You can use the shape height box and shape width box to change the height and weight respectively of a shape or picture.

Size Group



Advertisements

Excel Charts &-8211; Home

Excel Charts &-8211; Introduction

Excel Charts &-8211; Creating Charts

Excel Charts &-8211; Types

Excel Charts &-8211; Column Chart

Excel Charts &-8211; Line Chart

Excel Charts &-8211; Pie Chart

Excel Charts &-8211; Doughnut Chart

Excel Charts &-8211; Bar Chart

Excel Charts &-8211; Area Chart

Excel Charts &-8211; Scatter (X Y) Chart

Excel Charts &-8211; Bubble Chart

Excel Charts &-8211; Stock Chart

Excel Charts &-8211; Surface Chart

Excel Charts &-8211; Radar Chart

Excel Charts &-8211; Combo Chart

Excel Charts &-8211; Chart Elements

Excel Charts &-8211; Chart Styles

Excel Charts &-8211; Chart Filters

Excel Charts &-8211; Fine Tuning

Excel Charts &-8211; Design Tools

Excel Charts &-8211; Quick Formatting

Excel Charts &-8211; Aesthetic Data Labels

Excel Charts &-8211; Format Tools

Excel Charts &-8211; Sparklines

Excel Charts &-8211; PivotCharts

Excel Charts &-8211; Quick Guide

Excel Charts &-8211; Useful Resources

Excel Charts &-8211; Discussion

UPSC IAS Exams Notes

Developer&-8217;s Best Practices

Questions and Answers

Effective Resume Writing

HR Interview Questions

Computer Glossary

Who is Who