From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Creating dynamic charts with in-cell conditional formatting

Creating dynamic charts with in-cell conditional formatting - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Creating dynamic charts with in-cell conditional formatting

- [Instructor] Sometimes using a full-fledged chart in Excel 2 gives you an ideal display of the numbers in question. 3 In this worksheet, maybe what we would rather do 4 is simply show within the cell itself 5 a relative depiction of how many vehicles 6 each of our salespersons has sold in a given year. 7 So let's apply conditional formatting in column C. 8 Selecting the column first, on the home tab, 9 conditional formatting. 10 Recognize that you could explore 11 and you might well have explored different icon sets. 12 This would give you one way 13 to categorize the data in groupings. 14 Color scales could be another option here too, 15 where the greens represent the higher numbers, 16 the red lower, or the reverse this way, 17 but data bars actually could look like actual bar charts. 18 In other words, horizontal bars. 19 You'll notice that there are two major types, gradient fill. 20 This may or may not be your preference,…

Contents