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” »
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.
Simple chart for this table looks like this:
How to automatically highlight columns? Continue reading “Conditional Formatting in column (bar) charts” »