Join Dennis Taylor for an in-depth discussion in this video Use special tricks for working with dates in Charts, part of Excel Tips Weekly.
- [Voiceover] Excel's ability to handle date and time…arithmetic is a powerful tool, and generally works smoothly…but when you're working with charts certain aspects…of working with days become problematic.…I've got some list of data here, and you’ll notice that…this list here and the one just below it are identical…in all respects except for the upper left hand corner.…Similarly that should cause no particular problems.…Let's create a chat from the data.…Rather than highlighting the data, if the data that…you want to use in a chart is surrounded by empty cells…and/or worksheet boundaries, you need to only click…within the data and you can quickly get a chart with alt F1.…
Looks pretty good, and then you start…looking at some of the details here.…First of all, looks like the years didn’t get…picked up across the bottom, it just says, one through six.…Then you look a little more closer in the legend…and you see that although there should be an indicator…for domestic Europe, Asia, and Australia,…there is also one for region, a blue column.…
Skill Level Appropriate for all
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.
Excel Tips - New This Week
- 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.Cancel
Take 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.