From the course: Excel Data Visualization: Designing Custom Visualizations

Unlock this course with a free trial

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

Value-based formatting

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…

Contents