Creating a column or bar chart

Keyboard Shortcuts

Creating a column or bar chart within the Power View sheet in Microsoft Excel 2013 allows you to obtain a better visual idea of your data. This video explains how to turn your table into a column or bar chart in Microsoft Excel 2013, a program in Microsoft Office, and how to change the layout of the chart. For example, you may want to switch the Y and X axes to display different data; this video will show you how. It also explains how to align the legend and how to insert data labels.

After you add a table to a Power View sheet, you can summarize that table's data…by creating a chart,…and in this movie, I will show you how to create and work with both column and bar charts.…I will use as my sample file the ColumnAndBar workbook, which you can find in the…Chapter12 folder of your Exercise Files archive.…I've displayed the Power View2 sheet, which contains a Power View sheet and a table.…To create a chart based on this table, I'll click anywhere in the body of the…table, and then click the Design tab, and in the Switch Visualization area, I…can select the type of chart that I want to create, and in this case, I will…click a Column Chart.…

I have three options: Clustered Column, Stacked Column, and 100% Stacked Column.…The most common version is the Clustered Column, so I'll go ahead and click that…to show you what the chart looks like, and I'll resize it, so it's more visible.…You can see that Power View created the chart with the department along the…bottom, sales levels along the top, and each one of the bars represents a month;…

Resume Transcript Auto-Scroll

Author

Released

4/11/2013

Join Curt Frye as he explains how to leverage PivotTables to summarize, sort, count, and chart your data in Microsoft Excel. Curt shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to enhance PivotTable with macros, DAX expressions, and the PowerPivot add-in for analyzing millions of rows of data.