From the course: Excel Data Visualization: Designing Custom Visualizations
Unlock this course with a free trial
Join today to access over 23,100 courses taught by industry experts.
Value-based formatting - Microsoft Excel Tutorial
From the course: Excel Data Visualization: Designing Custom Visualizations
Value-based formatting
- [Instructor] Okay, our next demo's about value-based dynamic formatting, which is essentially trying to format individual data points within a series with unique formatting rules based on its value. So, to give you an example, let's look at our value-based formatting tab, and here, I've just got two columns of data, looking at click volume by day. So, if I were to select A and B, just insert your basic column chart, now, as you can see, if I right click the series and format, any changes I make, here, like fill, for instance, are applied to the entire series, but what if I want to feature or highlight individual data points or columns based on their values? So, let's say I want to highlight any point where click volume is greater than 8,000, so this point, this one, this one, and so on and so forth, you could individually select data points and manually change their fill, but that's obviously not a scalable solution, and it doesn't allow you to change or adjust your thresholds to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
(Locked)
Setting expectations1m 8s
-
(Locked)
Image overlay chart6m 1s
-
Binary ranges5m 2s
-
(Locked)
Automation with OFFSET and COUNTA7m 8s
-
(Locked)
Interactivity with form controls12m 30s
-
(Locked)
Animating changes over time14m 3s
-
(Locked)
Building a dynamic dashboard, part 116m 10s
-
(Locked)
Building a dynamic dashboard, part 212m 8s
-
(Locked)
Value-based formatting10m 10s
-
(Locked)
Dynamic series selection10m 26s
-
Custom pacing chart10m 23s
-
(Locked)
Custom gauge chart9m 58s
-
(Locked)
Visualizing percentages with arrays7m 16s
-
(Locked)
-