Join Dennis Taylor for an in-depth discussion in this video Creating dynamic charts with in-cell conditional formatting, part of Excel Tips Weekly.
- View Offline
- 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…
Skill Level Appropriate for all
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.