This tutorial covers all the basics, including, 1) getting to know the elements of a chart, 2) modifying a basic chart to meet your needs, 3) applying a predefined chart layout and chart style for a professional look, 4) adding eye-catching formatting to a chart, and 5) reusing charts by creating chart templates.

In Lesson 2 of the Excel Skills Builder, you learn about how to create a chart and other ways to visualize your data. (The Excel Skills Builder is a training series of short videos (typically under 5 minutes each) that give you an overview of a task or feature in Excel.)

Excel comes with lots of chart types, including column, line, pie, and so on. However, many of you asked for more information about other kinds of charts. This post covers how to work with floating column charts, Gantt charts, combination charts, and organization charts.

A sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases or to highlight maximum and minimum values. This tutorial explains 1) what sparklines are, 2) why you should use them, 3) how to create one, and 4) how to customize them.

That’s a good question! Choosing the wrong chart type for your data can easily happen when it comes to line and scatter charts. They look very similar, especially when a scatter chart is displayed with connecting lines, but there is a big difference in the way each of these chart types plots data along the horizontal and vertical axes.

Often, you’ll find it is useful to create charts which compare and analyze different types of data. For example, you might want to compare share price with trading volume. In Excel, you can make a chart easier to understand by using different chart types in the same chart, and by using a secondary vertical axis to plot values that are in a different value range. You can read this post to learn how, or you can watch this video: Combine two or more chart types in a chart

If haven’t found what you’re looking for, leave a comment, and we’ll see if we can write another blog post.