Learn how to avoid misleading visuals when rescaling the value (Y) axes on column and line charts.
- [Instructor] If you work with charts in Excel, … and particularly column charts and line charts, … you have some scaling options … that you might not be aware of. … And sometimes they can be used in a misleading way. … On this first worksheet here, … we want to create a chart based on this data. … And we can either highlight the data, which is typical, … and actually the recommended way, … but if the data we're looking at … is surrounded by empty cells and/or worksheet boundaries, … we can simply click within it. … And a quick way to create a chart is ALT+F1, … that's with the function key F1, ALT+F1, … we've got a column chart, drag it off to the right. … And by the way, a quick way to pull in a title here, … we don't want Chart Title to stay there, … I want that data over in cell A1. … That happens to be a merged cell, … that's not a prerequisite. … But we can simply click Chart Title, type =, … and go click that title … that's in our work sheet, and Enter. … That's handy. … Now, let's say that we want to accentuate …
Author
Updated
2/23/2021Released
1/16/2015Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Intermediate
Duration
Views
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Related Courses
-
Excel: PivotTables for Beginners
with Dave Ludwig23m 52s Beginner -
Presentation Tips Weekly
with Jole Simmons3h 24m Intermediate -
Excel: Lookup Functions in Depth
with Dennis Taylor1h 8m Intermediate
-
Excel Tips - New This Week
-
Previous Episodes
-
Quick formatting tips8m 9s
-
Create an organization chart8m 56s
-
Auditing9m 1s
-
Adding comments and shapes7m 35s
-
Creating an Excel template7m 57s
-
Adjust banded-row formatting14m 35s
-
Dealing with circular errors8m 20s
-
Sorting tips and shortcuts8m 40s
-
Freeze Panes and Split5m 30s
-
Calculate % of change5m 41s
-
How to adjust names5m 45s
-
Sorting by moving columns4m 16s
-
Using the Solver Add-in4m 29s
-
Create picture links5m 37s
-
Display large values5m 16s
-
Create a powerful macro4m 40s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Avoid misleading visuals when rescaling