Two different chart types in one graph

In this example, I will show you how to combine column chart with line chart. For the rest of chart types is the same procedure. Continue reading “Two different chart types in one graph” »

Conditional Formatting in column (bar) charts

Excel does not support conditional formatting in charts, but we can solve it with a little trick. Original data will be split into a new table and then will be displayed by Stacked Column chart. The result will look like conditional formatting.


Let us have following data table. We want to highlight a column in chart having a value less than 20.

Source table - example1

Simple chart for this table looks like this:

Simple column chart - example1

How to automatically highlight columns? Continue reading “Conditional Formatting in column (bar) charts” »

Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress