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.

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.

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.

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.

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).

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.

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.

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.

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.