Series Overlap Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/series-overlap/ Bestselling Excel and Power BI Courses Thu, 16 Mar 2023 23:25:24 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Series Overlap Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/series-overlap/ 32 32 How to Create Conditional Bar Charts in Excel https://www.xelplus.com/excel-conditional-bar-charts/ Thu, 23 Jul 2020 09:00:00 +0000 https://www.xelplus.com/?p=10848 Properly show the variance to previous period using conditionally formatted bar charts. There is a simple trick to getting the negative bars in a different color to positive bars. You'll also discover a bonus trick to conditionally format any bars based on a logic.

The post How to Create Conditional Bar Charts in Excel appeared first on Xelplus - Leila Gharani.

]]> Excel Charts: Special Excel Graphs (InfoCharts) https://www.xelplus.com/excel-infocharts-special-excel-graphs/ Thu, 25 May 2017 08:08:00 +0000 https://www.xelplus.com/?p=12392 If you want your charts to grab attention, it's worth spending some time on customizing the shapes and conditionally formatting them in a dynamic manner, so that the highlighted value changes with the data. In this tutorial, we will walk through an example of customizing a chart in Excel.

The post Excel Charts: Special Excel Graphs (InfoCharts) appeared first on Xelplus - Leila Gharani.

]]>