In this video, we'll plot American generations in a chart with floating bars. This seems like a simple problem, but a solution takes a little creative thinking...Read more
Excel charts can exist in as an embedded object, floating above the cell grid, or, in a sheet all by themselves. In this video, we'll look at how to move charts from one state to the other...Read more
Excel charts have a surprisingly large number of parts, each with its own name. In this video, we break down a sample chart into parts, and give you the name for each.Read more
In this video, we'll look at how to create a pie chart in Excel. Pie charts show a "part to whole" relationship, and they work best with a limited number of categories...Read more
In this video, we look at how to create a basic column chart in Excel, and how to use custom number formats to show dates as month names, and currency in thousands.Read more
In this video, we'll look at how to create a 100% stacked column chart, which shows the proportional breakdown of multiple data series in stacked columns...Read more
In this video, we'll look at how to make a stacked area chart. Stacked area charts are useful to show changes in a part-to-whole relationship over time...Read more
In this video, we'll look at how to create a stacked column chart. In a stacked column chart, data series are displayed as vertical columns, stacked one on top of the other...Read more
In this video, we'll look at how to build a clustered column chart in Excel. Clustered column charts can be a good way to show trends in each category, when the number of data series and categories is small...Read more
In this video, we'll look at how to create a radar chart. Radar charts can be used to plot the performance, satisfaction, or other rating data across multiple categories in a single chart...Read more
In this video, we'll look at how to make a 100% stacked area chart. Stacked area charts can show changes in a part-to-whole relationship over time...Read more
In this video, we'll look at how to create a bar chart in Excel to show survey data. Bar charts are good for long labels, since there is plenty of room for text to the left of the bars. ...Read more
In this video, we'll look at several options for creating a pivot chart. A pivot chart is an extension of a pivot table, so in order to have a pivot chart you must also have a pivot table...Read more
In this video, we'll look at how to add additional pivot charts based on the same data. When the data is refreshed, all charts will update at the same time...Read more