Join Dennis Taylor for an in-depth discussion in this video Creating dynamic charts with in-cell conditional formatting, part of Excel Tips Weekly.
- Sometimes using a full-fledged chart in Excel…gives you an ideal display of the numbers in question.…In this worksheet maybe what we would rather do…is simply show within the cell itself…a relative depiction of how many vehicles…each of our sales persons has sold in a given year.…So let's apply conditional formatting in column C.…Selecting the column first,…on the Home tab Conditional Formatting.…Recognize that you could explore, and you might well…have explored, different icon sets.…This would give you one way to categorize…the data in groupings.…
Color Scales could be another option here, too,…where the greens represent the higher numbers,…the red lower, or the reverse this way.…But Data Bars actually could look like actual bar charts.…In other words, horizontal bars.…You'll notice that there are two major types.…Gradient Fill, this may or may not be your preference,…but we see what happens here as we're sliding over…and getting a preview here.…Notice the bigger the number, the wider the bar.…To look more like a bar chart, you might…
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
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
Freeze Panes and Split New5m 30s
- 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.