Login & Start Learning!

or

VIDEO PLAYLIST

Testimonials

Patricia Henry

“During my last semester of college, I only knew a little bit of Excel and was in the job hunt for my post grad life. I purchased the student packet from Excel Tutor and learned may more than I ever thought possible about Excel. I am so excited to put all my new Excel knowledge on my resume.”

Patricia H.
David Phillips

“ I’ve been working in the insurance industry for a few years now and have been trying to get my fellow colleagues to understand Excel and perform at a more efficient rate. I found this site and after completing the courses myself, I now have my entire department completing these courses! ”

David P.
Phil Banks

“My boss told me that I needed to find a way to be “more efficient and effective” for my daily tasks. That’s when I went hunting for an online Excel course. Excel Tutor was the answer! I learned so many tricks and I even received a promotion in my job last week due to what I learned from this website.”

Phil B.

Charts: Line Charts

  • Description
  • Discussion
Line charts are great for tracking data over time. Sometimes we want to compare different metrics on the same chart to see if they are moving together, or diverging. Unfortunately, one number may be measured in dollars ($) and another in percentage (%). When numbers are in very different scales, they are difficult to display in a meaningful way on a single chart. But, this video shows a great trick around this problem by applying a secondary axis, and like magic, the data can be compared!

Support Files:

Charts-Blank.xlsx Charts-Complete.xlsx

Leave a comment

(Your email address will not be published.)

2 comments “Line Charts

  • Avatar
    Austin August 5, 2018 - 3:40 PM

    I tried doing the Format Axis and I get this box on the right side instead of that larger option menu that should pop up. I followed the exact step in the video, I am confused.

    Attachment

    Reply

    • Avatar
      Neil Parsont August 6, 2018 - 7:58 AM

      Hi Austin,
      You may need to close that additional pop-up that is in your image. It appears you have a similar version of Excel so just double check what you are clicking and you should be able to get the same result as the video.

      Reply

Rate this Video:

Avatar

Members Also Watched

  • Introduction (2m 4s)

  • Task 5: 6 – 10 (3m 36s)

  • Task 5: 1 – 5 (2m 54s)

Loading...