About This Chapter
Create a Chart in Excel: Chapter Summary
Charts offer an efficient and highly visual way to communicate data. In Excel, you can choose from several different types of charts, such as pie, column, bar or line charts, to best display relationships among data values. This chapter will not only show you how to create charts and graphs, but also how to make changes to them.
These videos break down each step to creating and editing charts and graphs so you are easily able to grasp the information and apply it to your own work. Each lesson includes an interactive quiz to allow you to test your comprehension of the skills covered by the instructor.
Topics covered in this chapter include:
- Overview of chart and graph options
- Switching between types of charts
- Adding more data to your graphs
- Rearranging data in charts and graphs
- Using the Quick Analysis tool
(Note: All demonstrations in this chapter will use Microsoft Excel 2013. Certain features, tools or displays may be different in other versions.)
Excel is a trademark of the Microsoft Corporation, which is not affiliated with Study.com.
1. Excel Charts & Graphs: Summarizing Data Visually
Charts and graphs help to make information easier to understand. When you have a worksheet full of numbers, inserting a chart will help the viewers digest comparisons and trends. This lesson will introduce you to charts and graphs in Excel.
2. How to Change a Chart Type in Excel
If you are anything like me, you have a hard time deciding what type of chart you should create. I'll start with bars, change to columns, and end up with lines. This lesson is all about changing the type of an existing chart.
3. Switch Between Rows & Columns in an Excel Graph's Source Data
When creating charts in Excel, the series and category, or rows and columns, may at times need to be switched. Excel has a command called Switch Row/Column. This lesson will review the steps to using this command.
4. Quick Analysis in Excel
If you have ever thought about adding analytic elements to your worksheet, such as charts, conditional formatting or sparklines, then the Quick Analysis tool is for you. This lesson will introduce you to the tool and explain how easy it is to use.
Earning College Credit
Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.
To learn more, visit our Earning Credit Page
Transferring credit to the school of your choice
Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.
Other chapters within the Intro to Excel: Essential Training & Tutorials course
- Creating Worksheets & Workbooks in Excel
- Formatting Worksheets & Workbooks in Excel
- Customizing Options & Views in Excel
- Configure to Print & Save in Excel
- Format Cells & Ranges in Excel
- Insert Data in Cells and Ranges in Excel
- Filter and Sort a Table in Excel
- Order & Group Cells & Ranges in Excel
- Create a Table in Excel
- Modify a Table in Excel
- Use Cell Ranges & References for Formulas & Functions in Excel
- Summarize Data with Functions in Excel
- Functions with Conditional Logic in Excel
- Format & Modify Text with Functions in Excel