Excel Charts & Graphs and SmartArt Graphics for Beginners

In this video lecture:

1. You will learn how to create an Excel chart or graph selecting the data series manually.
2. And you will be introduced with the “Insert” Chart dialog box.

In this video lecture:

1. You will learn in details how to create an Excel chart using the Recommended Charts command.
2. And you will learn how to apply Chart Styles on a chart.

In this video lecture, you will learn:

1. How to create an Excel chart using the commands under the Charts group.
2. How to change the color of a chart.
3. How to change the Layout of a chart.
4. How to switch between Row and Column.
5. How to change Chart type.
6. How to create default Excel chart using keyboard shortcut.
7. How to create chart in Chart Sheet using keyboard shortcut.
8. And how to change the default Excel chart.

In this video lecture:

1. You will learn how to create a Combo Chart.
2. And then you will be introduced with the different parts of a chart.

In this video lecture:

1. You will work with the three icons that appear on the top-right corner when you select a chart. They are:
   1. Chart Elements
   2. Chart Styles
   3. And Chart Filters
2. More or less you have worked with them in earlier videos, you will learn their uses in details in this video.

In this video lecture, you will learn how to:

1. Resize a chart
2. Move a chart from one location to another
3. In the same worksheet
   1. From one worksheet to another
   2. From one workbook to another
   3. And even from a worksheet to a chart sheet.
4. You will also learn how to delete a chart
5. And how to Print only the chart, not the whole worksheet.

In this video lecture:

1. You will learn how to create these three chart types:
   1. Column Chart
   2. Bar Chart
   3. And Line Chart
2. You will see all these chart types have two major sub-categories: 2-D and 3-D.

In this video lecture:

1. You will learn how to create and customize a Pie chart in details.
2. You will learn how to create “Bar of Pie” chart and “Pie of Pie” chart.
3. And you will be introduced with the “Format Data Labels” task pane.

In this video lecture:

1. You will learn how to create and use of these three charts:
   1. XY or Scatter Chart
   2. Area Chart
   3. And Radar Chart.

In this video lecture, you will learn how to select a chart element. You can select a chart element in three ways:

1. Using your mouse pointer
2. Using Chart Elements control
3. And using your keyboard.

In this video lecture,

• You will learn how to find out the tools that you will use to format chart elements.

In this video lecture, you will learn how to work with the features under the Fill & Line tab to format a chart element. You will get two sub categories under this tab:

1. Fill
2. And Border

In this video lecture,

1. You will learn where to find out the Effects options.
2. You will also learn how to work with the different options under the Effects tab.

In this video lecture, you will learn how to work with the different options under the Size & Properties tab. The options are:

1. Size
2. Properties
3. Alt Text
4. And Alignment

In this video lecture,

1. You will learn how to format the data table of a chart.
2. You will learn how to change the axis of a data series
3. And you will also learn how to change the marker of a data series.

In this video lecture,

1. You will learn how to work with
2. Value Axis related Format Axis task pane options
3. And Category Axis related Format Axis task pane options.

In this video lecture,

1. You will learn two topics:
2. The first topic is: how to handle missing data points in a chart
3. And second topic is: how to show those data in a chart that are from hidden rows and columns.

In this video lecture,

1. You will learn how to add Error Bars to a chart
2. You will also learn how to show Trend-line in a chart.

In this video lecture,

1. You will learn how to save a chart as a template.
2. You will also learn how to apply and manage chart templates.

In this video lecture, you will learn about two controls of Format Data Series task pane. They are:

1. Series Overlap
2. Gap Width

Combination charts are generally called Combo charts in Excel. These types of charts have so many uses. In this video lecture, I have talked about how to create a complex type Excel combo chart.

In this video lecture,

1. You will learn how to use images as the background of a chart
2. You will also learn how to use a shape as the columns of chart.

In this video lecture,

• You will learn how to make a thermometer chart in Excel.

In this video lecture,

• You will learn how to make a gauge chart in Excel.

In this video lecture,

• You will learn how to create a comparative histogram chart.

In this video lecture:

1. You will learn how to create a basic Gantt Chart using Stacked Bar chart.
2. You will also learn how to reverse the Category axis and change the position of the Labels of Horizontal axis.
3. And you will learn other topics like:
   1. Changing the value of Major Units
   2. And changing Gap Width between Data Series

In this video lecture, you will learn how to use different tools to format a picture. The tools are:

1. Corrections tool – this tool is used to soften, sharpen, increase brightness or contrast
2. Color tool – this tool is used to do Color Saturation, Color Tone and Recolor
3. Artistic Effects
4. Picture border – this tool is used to add border to a picture
5. Picture Effects – this tool is used to add effects to an image
6. Picture Layout – you can change the layout of a picture using this tool.

I have also discussed about the commands under the Size group.

In this video lecture,

1. You will learn how to remove background from an image using Excel
2. And you have learned the use of the tools in the Background Removal tab that appears when you click on the Remove Background command in the Picture Tools Format contextual tab.

In this video lecture, you will learn how to work with SmartArt Graphics in details:

1. How to insert,
2. How to change the layout, color, styles of the SmartArt graphics,
3. How to change the shape, color and other features of individual object in a SmartArt Graphic.
4. How to add text, how to change direction
5. And many more features.

In this video lecture,

1. You will learn how stacking order works for Images, Shapes and Smart Arts,
2. You will learn how to change the stacking order,
3. And you will learn how to hide and unhide all of them using Selection task pane.

In this video lecture,

1. You will learn how to group, ungroup and regroup the objects in a worksheet,
2. You will also learn how to align objects in different ways.

In this video lecture,

1. You will learn how to show the cell value as an object text,
2. You will also learn about Excel PI and ROUND functions.

In this video lecture,

1. You will learn how to change the styles of Drawing and SmartArt tools text objects.

In this video lecture,

1. You will learn how to write mathematical equation in an Equation Editor.
2. You will also learn how to design the editor.

Want to get an in-depth knowledge of Microsoft Excel? Join my Advanced Excel 2013 Training + Build a Pro Excel Template course for 50% Off. Or join my Data Analysis in Excel with Statistics: Get Meanings of Data course for 50% Off.