Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Creating An Excel Chart With Conditional Formatting.mp4

K2 Enterprises
5.08K subscribers
<__slot-el>
<__slot-el>
19K views 13 years ago
Conditional formatting is a great tool for automatically formatting data in Excel based on the conditions present in a cell(s). For example, we can use conditional formatting to highlight automatically all unfavorable budget variances in red and all favorable budget variances in blue. Given the power of using conditional formatting on traditional Excel ranges, many Excel users would like to use this tool on charts and often ask the question "Can we apply conditional formatting to charts". The short answer is "No, conditional formatting does not work on chart data." The longer answer is "With a little creativity, we can trick Excel into applying what appears to be conditional formatting." In this tip, we will show you how, with a little creativity, you can create a chart in Excel with conditional formatting. ...more
...more
Creating An Excel Chart With Conditional Formatting.mp4
29Likes
19,213Views
2012Apr 29
Conditional formatting is a great tool for automatically formatting data in Excel based on the conditions present in a cell(s). For example, we can use conditional formatting to highlight automatically all unfavorable budget variances in red and all favorable budget variances in blue. Given the power of using conditional formatting on traditional Excel ranges, many Excel users would like to use this tool on charts and often ask the question "Can we apply conditional formatting to charts". The short answer is "No, conditional formatting does not work on chart data." The longer answer is "With a little creativity, we can trick Excel into applying what appears to be conditional formatting." In this tip, we will show you how, with a little creativity, you can create a chart in Excel with conditional formatting.

Follow along using the transcript.

K2 Enterprises

5.08K subscribers