Copyright

Switch Between Rows & Columns in an Excel Graph's Source Data

Switch Between Rows & Columns in an Excel Graph's Source Data
Coming up next: Quick Analysis in Excel

You're on a roll. Keep up the good work!

Take Quiz Watch Next Lesson
 Replay
Your next lesson will play in 10 seconds
  • 0:01 Making the Switch
  • 0:42 Excel Charts - Refresher
  • 2:21 Switch Row/Column Command
  • 3:09 Lesson Summary
Save Save Save

Want to watch this again later?

Log in or sign up to add this lesson to a Custom Course.

Log in or Sign up

Timeline
Autoplay
Autoplay
Speed

Recommended Lessons and Courses for You

Lesson Transcript
Instructor: Karen Sorensen

Karen has a Bachelors in Communications. She has 25 years of experience in Information Systems, Adult Learning and Virtual Training.

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.

Making the Switch

Imagine you entered a bunch of numbers, then inserted a chart to visually enhance the worksheet and make the information easier to digest. You hand it off to your boss who likes it, but he wants the columns switched, or in other words, the category and series need to be reversed. You prepare to start over and re-create the chart. But wait! There is an easier way.

This lesson will start with a Quick review about charts in Excel, learning what is meant by the x-axis, y-axis, series and category. You will learn how to switch between the two using the Switch Row/Column command.

Excel Charts - Refresher

Before you learn how to switch rows and columns, let's review the basic elements of an Excel chart. Charts in Excel can be very helpful when you need to display data graphically. This usually makes the numbers and calculations a bit easier to read and understand. Using a chart will help the viewer easily see which numbers are high or low and which numbers may be going up or down.

Most charts have two axis. I like to think of them as the sides of the chart or graph. You have the x-axis, which is the horizontal part of the chart, and the y-axis, which is the vertical part.

Let's take a look at a sample chart and identify its components. Imagine you have created a worksheet with the revenue results for the last four years. You have a column for each year and the quarterly revenue results displayed by row. To insert the chart, you highlighted the data, clicked on Insert and selected a Column Chart.

Excel Chart

If you look at the chart, we have five key elements.

To unlock this lesson you must be a Study.com Member.
Create your account

Register to view this lesson

Are you a student or a teacher?

Unlock Your Education

See for yourself why 30 million people use Study.com

Become a Study.com member and start learning now.
Become a Member  Back
What teachers are saying about Study.com
Try it risk-free for 30 days

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.

Create an account to start this course today
Try it risk-free for 30 days!
Create an account
Support