Excel Charts - In depth

Become A Professional Data Presenter In An Hour
3.1 (8 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
361 students enrolled
$25
Take This Course
  • Lectures 26
  • Contents Video: 1 hour
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2014 English

Course Description

In this Excel Charts - In depth video course, Nurture Tech Academy introduces you to the most simplest way to understand how to create a Chart and other advanced charting techniques.

In this online course we will try to find out first that in which circumstances which chart type is most appropriate to present our Excel data.

This program will cover the basics of Excel Charts, types of charts in Excel (e.g. Column, Bar, Line, Pie, Pie of Pie, Bar of Pie, Area, bubble chart etc.).

Then will gradually move to the Advanced Charting techniques like, selecting the a chart elements, how to modify the chart area, plot area, working with chart titles, axis titles, data series, handling missing data, modifying 3-D charts, creating a combination of Charts in one single chart type, Creating and saving Chart templates etc.

Then we will also see some Excel charting tricks like creating a Picture Chart etc.

By the completion of this online training course, you will be fully versed, and capable of using any any types of Charts in Microsoft Excel 2007/2010/2013 in a commercial Environment.

What are the requirements?

  • Microsoft Excel 2007/2010/2013

What am I going to get from this course?

  • How to prepare a Chart in Excel
  • What type of Chart is most suitable in which situation
  • Basics of creating an Excel Chart
  • Types of Charts in Excel
  • Advanced Charting techniques
  • Excel Chart Tricks
  • Suitable for beginners to advanced users. ideal for users who learn faster when shown.
  • Charts explained in most logical and simplest manner
  • Videos created by Microsoft Certified Trainer
  • Downloadable exercise files for practical learning

What is the target audience?

  • Working Professionals & Students

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to Excel Charts
02:58

In this lecture we will talk about what we will learn in this whole video tutorial. We will start with "What is a Chart", then we will see what kinds of chart types available in Excel , how to use chart handles, Different types of charts, What type of chart is suitable in what circumstances, then we will see some advanced charting techniques and gradually we will move towards the conclusion.

I just want you to perform what we will learn in each video using the excel files i have uploaded with each video to have a feel of all the functions.

Section 2: How to Prepare a Chart in Excel
02:46

Charts are used to display series of numeric data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data.

To create a chart in Excel, you start by entering the numeric data for the chart on worksheet. Then you can plot that data into a chart by selecting the chart type that you want to use on the Office Fluent Ribbon (Insert tab,Charts group).

There are two types of charts in Excel.

1. Embedded chart

2. Chart sheet

02:45

Design & layout is all about the cosmetic changes you make to the chart to make it more presentable in front of the spectators.

After you create a chart, you can instantly change its look. Instead of manually adding or changing chart elements or formatting the chart, you can quickly apply a predefined layout and style to your chart. Excel provides a variety of useful predefined layouts and styles (or quick layouts and quick styles) that you can select from, but you can customize a layout or style as needed by manually changing the layout and format of individual chart elements.

02:52

You can also link chart and axis titles to corresponding text in worksheet cells by creating a reference to those cells. Linked titles are automatically updated in the chart when you change the corresponding text on the worksheet.

This feature is really helpful when we create Excel dashboards in excel to make dynamic we have to link the tile and axis title to make is work properly.

02:33

To make a chart easier to understand, you can add title, such as a chart title and axis titles, to any type of chart. Axis titles are typically available for all axes that can be displayed in a chart, including depth (series) axes in 3-D charts. Some chart types (such as radar charts) have axes, but they cannot display axis titles. Chart types that do not have axes (such as pie and doughnut charts) cannot display axis titles either.

02:11

To quickly identify a data series in a chart, you can add data lables to the data points of the chart. By default, the data labels are linked to values on the worksheet, and they update automatically when changes are made to these values.

02:02

You can also show a data table for a line chart, area chart, column chart, or bar chart. A data table displays the values that are presented in the chart in a grid at the bottom of the chart. A data table can also include the legend keys.

Section 3: Preparing Different Types of Charts
02:03

A column chart shows data changes over a period of time or illustrates comparisons among items. Column charts have the following chart sub-types:

  • Clustered Column This type of chart compares values across categories. It is also available with a 3-D visual effect. As shown in the following chart, categories are organized horizontally, and values vertically, to emphasize variation over time.
  • Stacked Column This type of chart shows the relationship of individual items to the whole, comparing the contribution of each value to a total across categories. It is also available with a 3-D visual effect.
  • 100% Stacked Column This type of chart compares the percentage each value contributes to a total across categories. It is also available with a 3-D visual effect.
  • 3-D Column This type of chart compares data points along two axes. For example, in the following 3-D chart, you can compare four quarters of sales performance in Europe with the performance of two other divisions.
01:33

A bar chart illustrates comparisons among individual items. Bar charts have the following chart sub-types:

  • Clustered Bar This type of chart compares values across categories. It is also available with a 3-D visual effect. In the following chart, categories are organized vertically, and values horizontally, to place focus on comparing the values.
  • Stacked Bar This type of chart show the relationship of individual items to the whole. It is also available with a 3-D visual effect.
  • 100 % Stacked Bar This type of chart compares the percentage each value contributes to a total across categories. It is also available with a 3-D visual effect.
03:04

A line chart shows trends in data at equal intervals. Line charts have the following chart sub-types:

  • Line This type of chart displays trends over time or categories. It is also available with markers displayed at each data value.
02:42

We can reduce the unwanted axis gap by formatting the axis through format axis title.

01:22

An area chart emphasizes the magnitude of change over time. Area charts have the following chart sub-types:

  • Area This type of chart displays the trend of values over time or categories. It is also available with a 3-D visual effect. By displaying the sum of the plotted values, an area chart also shows the relationship of parts to a whole. For example, the following area chart emphasizes increased sales in Washington and illustrates the contribution of each state to total sales.
  • Stacked Area This type of chart displays the trend of the contribution of each value over time or categories. It is also available with a 3-D visual effect.
  • 100% Stacked Area This chart type displays the trend of the percentage each value contributes over time or categories. It is also available with a 3-D visual effect.
02:34

A pie chart shows the size of items that make up a data series, proportional to the sum of the items. It always shows only one data series and is useful when you want to emphasize a significant element in the data.

02:33

Pie of Pie This is a pie chart with user-defined values extracted and combined into a second pie. For example, to make small slices easier to see, you can group them together as one item in a pie chart and then break down that item in a smaller pie or bar chart next to the main chart.

Bar of Pie This is a pie chart with user-defined values extracted and combined into a stacked bar.

02:07

When you create a graph in Excel, by default any numerical axis will use the linear scale. This means that each tick on the axis is the same number of units away from the adjacent ticks. When you have a set of numbers that has both very small numbers and very large numbers, a linear scale may not display the information usefully. To fix this issue, you can change an axis on an Excel graph to use a logarithmic scale, which has each tick on the axis represents an order of magnitude over the initial tick mark. For example, if the first tick represents 10, the second tick would be 10 to the second power, or 100, and the third tick would be 10 to the third power, or 1,000.

01:20

A bubble chart is a type of xy (scatter) chart. It compares sets of three values and can be displayed with a 3-D visual effect. The size of the bubble, or data Marker, indicates the value of a third variable. To arrange your data for a bubble chart, place the x values in one row or column, and enter corresponding y values and bubble sizes in the adjacent rows or columns.

Section 4: Advanced Charting Techniques
05:16

You can use the mouse to select chart elements on a chart sheet or in an embedded chart. However, if you are not sure where a specific element is located in the chart, you can select it in the Chart Objects box on the Chart toolbar. You can also select chart elements by using the keyboard.

03:06

Although the Chart Tools ribbon is full of cool things you can do to your chart, sometimes you might want more control. In earlier versions of Office, advanced formatting options were buried deeply in hard to find, complex dialog boxes. Now these options are available in clean, shiny, new task panes. Select the chart element (for example, data series, axes, or titles), right-click it, and click Format .

04:20

The plot area in a chart or graph in spreadsheet programs such as Excel refers to that area of the chart that graphically displays the data being charted.

02:04

After you create a chart, you might have to change its source data on the worksheet. To incorporate these changes in the chart, Microsoft Office Excel provides various ways to update a chart. You can instantly update a chart with changed values, or you can dynamically change the underlying source data. You can also update a chart by adding, changing, or removing data.

03:57

When you create a line chart in Excel, missing data points (blank cells) aren’t plotted, which leaves gaps in the chart. Excel provides two other ways of handling missing data:

* Treat the missing data as zero.

* Interpolate the data by connecting the line between the nonmissing data points.

02:57

To make a 3-D chart (a chart type that displays data on a third, depth axis, such as a 3-D column, 3-D line, or 3-D surface chart) easier to read, you can change the 3-D format, rotation, and scaling of the chart.

You can change the plotting order of data series so that large 3-D data markers do not block smaller ones.

03:01

A combination chart uses two or more chart types to emphasize that the chart contains different kinds of information.

02:55

If you want to create another chart like the one that you just created, you can save the chart as a template that you can use as the basis for other similar charts.

02:11

You can enhance a chart by inserting a picture (such as a business logo) in the chart area. Or you can use a picture fill to draw attention to specific chart elements such as the chart area, the plot area, the data marker (in column, bar, area, bubble, 3-D line, and filled radar charts), the legend (in 2-D and 3-D charts), or the 3-D walls and floor of a chart.

You can also copy a picture to a chart or to chart elements such as data markers in 2-D line charts, scatter charts, or an unfilled radar chart. If a picture is no longer needed, you can remove it.

Section 5: Conclusion
01:42

Thank you for taking this course. Hope you enjoyed this course. If you have any query related to this course you can just reach me through the website www.nurturetechacademy.in by filling up the form on home page or through sending me a msg through udemy account.

Happy learning guys,

Lokesh

Nurture Tech Academy

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Nurture Tech Academy, Microsoft Office Specialist

Nurture Tech Academy (http://nurturetechacademy.in/) is Microsoft Authorised Testing Centre, providing blend of instructor-led and online training programs in Basic Excel, Advanced Excel, VBAs, Macros, and other MS Office applications. It has a team of Microsoft Certified Trainers who are specialist in their respective fields.

Ready to start learning?
Take This Course