Jump to content


Excel 2013 essential skill - Session 5 - lesson 13

1 reply to this topic

#1 gus



  • Members
  • Pip
  • 1 posts

Posted 07 June 2016 - 08:00 AM

I apologize if my question is a nonsense.

In session 5 , Lesson 13 ( Understand data series and categories) at time 02:51 I find an error because for me month  are categories and not series. And so on in next graph. I dont know if it is wright what I write before... but I nead an answer..



#2 Mike


    Advanced Member

  • Administrators
  • 190 posts

Posted 08 June 2016 - 02:30 PM

Hi Gus


You didn't mention whether you are using Excel 2007, Excel 2010, Excel 2013 or Excel 2016 so I've guessed it is Excel 2013.


I've just watched lesson 5-13 (Excel 2013).


The lesson teaches you that Series and Categories can be flipped using the Switch Row/Column button.  Every time you do this you'll find that the Month and Region change places.


Try clicking the button as directed in the lesson and you'll see that your Month Categories become Series.  Click a second time and they'll become Categories again.


Best Regards



Mike Smart





Mike Smart is the author of ten world best-selling Excel books. The books are available in printed form for for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Mike has also recorded over 850 video lessons (that you can watch online) for Excel 2007, Excel 2010 and Excel 2013.
Mike Smart is also part of the team that answers questions posted on the ExcelCentral.com forums.

Reply to this topic


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users