Jump to content


How to switch rows and columns in Excel charts

charts switch row/column data source

  • Please log in to reply
1 reply to this topic

#1 TeachtheKids



  • Members
  • Pip
  • 1 posts

Posted 12 September 2013 - 06:08 PM

I can't figure out how to match up the data to the correct bar on the chart.  Example:  I have 9 percents that were figured out on my worksheet from comparing 3 countries and they are in columns.  When I try to make a basic chart Excel displays 3 sets of 3 bars in 3 matching colors.  This is what I want except I want to group the rows not the columns in the chart.  Please help, it seems simple but I can't figure it out.  Thank you

#2 Jonathan


    Forums Administrator

  • Administrators
  • 887 posts

Posted 12 September 2013 - 07:08 PM

The simplest way to do this is to select the chart and click: Chart Tools > Design > Data > Switch Row/Column (Chart Tools will appear on the ribbon when you click the chart). This will switch the values that are shown in the legend with the values in the X axis.




For a more detailed explanation of this, take a look at this video: Essential Skills Lesson 5-13: Understand Data Series and Categories.  This video lesson will also show you how to change chart backgrounds.


This setting can also be changed by right-clicking on the chart, clicking Select Data Source from the shortcut menu and then clicking Switch Row/Column from the dialog that appears.  For more information about this method and about changing the data sources of charts, watch this video lesson: Essential Skills Lesson 5-11: Change a chart's source data.


I hope this information is helpful.  Please reply if you're still having difficulty with this.

Jonathan is part of the professional team who answer Excel-related questions posted on the ExcelCentral.com forums.
Jonathan also tests our courses prior to publication and has worked on all of our ten world bestselling Excel books for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Jonathan has also worked on over 850 video lessons for or video courses covering Excel 2007, Excel 2010 and Excel 2013.
As well as extensive Excel knowledge, Jonathan has worked in the IT world for over thirteen years as a programmer, database designer and analyst for some of the world's largest companies.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users