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).
There are two types of charts in Excel.
1. Embedded chart
2. Chart sheet
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.
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.
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.
A column chart shows data changes over a period of time or illustrates comparisons among items. Column charts have the following chart sub-types:
A bar chart illustrates comparisons among individual items. Bar charts have the following chart sub-types:
A line chart shows trends in data at equal intervals. Line charts have the following chart sub-types:
We can reduce the unwanted axis gap by formatting the axis through format axis title.
An area chart emphasizes the magnitude of change over time. Area charts have the following chart sub-types:
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 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.
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.
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.
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.
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 .
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.
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.
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.
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.
A combination chart uses two or more chart types to emphasize that the chart contains different kinds of information.
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.
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.
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,
Nurture Tech Academy
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.