Excel Charts - In depth
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.
363 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Charts - In depth to your Wishlist.

Add to Wishlist

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.
363 students enrolled
Last updated 1/2014
English
Current price: $10 Original price: $25 Discount: 60% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Microsoft Excel 2007/2010/2013
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.

Who is the target audience?
  • Working Professionals & Students
Students Who Viewed This Course Also Viewed
Curriculum For This Course
26 Lectures
01:08:54
+
Introduction to Excel Charts
1 Lecture 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.

Preview 02:58
+
How to Prepare a Chart in Excel
6 Lectures 15:09

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

Preview 02:46

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.

Preview 02:45

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.

Preview 02:52

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.

How to Show Axis Title
02:33

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.

How to Show Data Lable
02:11

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.

Show data with chart in Data Table
02:02
+
Preparing Different Types of Charts
9 Lectures 19:18

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.
Column Chart
02:03

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.
Bar Chart
01:33

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.
Line Chart 1
03:04

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

Line Chart 2
02:42

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.
Area Chart
01:22

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.

Pie Chart
02:34

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.

Pie of Pie or Bar of Pie Chart
02:33

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.

Logarithmic Scale Chart
02:07

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.

Bubble Chart
01:20
+
Advanced Charting Techniques
9 Lectures 29:47

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.

Selecting Chart Elements
05:16

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 .

Use of Format Dialog box
03:06

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.

Modifying Chart & Plot Area
04:20

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.

Modifying Data Series
02:04

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.

How to handle Missing Data
03: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.

Modifying 3-D Charts
02:57

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

Creating Combination of Charts
03:01

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.

Creating a Chart Templates
02:55

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.

Creating Picture Charts
02:11
+
Conclusion
1 Lecture 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

Conclusion
01:42
About the Instructor
Nurture Tech Academy
4.0 Average rating
402 Reviews
13,015 Students
5 Courses
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.