Line Series Archives - Xelplus - Leila Gharani

Highlight Max & Min Values in an Excel Line Chart

Leila Gharani — Thu, 21 Mar 2019 17:01:00 +0000

Can you conditionally format an Excel line chart to highlight the maximum and minimum values? Can you do it in a dynamic way? You can. You just need to use this simple trick.

The post Highlight Max & Min Values in an Excel Line Chart appeared first on Xelplus - Leila Gharani.

Optimized Excel Line Charts: Prevent Drop to Zero

Leila Gharani — Fri, 01 Dec 2017 06:50:00 +0000

Learn how to create dynamic line charts and avoid common problems, such as line series dropping to zero and positioning the legend at the end of the line series.

The post Optimized Excel Line Charts: Prevent Drop to Zero appeared first on Xelplus - Leila Gharani.

Skip Dates in Excel Charts

Leila Gharani — Thu, 07 Sep 2017 10:40:00 +0000

Learn a simple method to deal with gaps in your data, specifically missing dates. You don't want to display them in a chart, but Excel treats a date axis as continuous and will try to connect the line.

The post Skip Dates in Excel Charts appeared first on Xelplus - Leila Gharani.

Excel Charts: Dynamic Line Series Labels

Leila Gharani — Mon, 18 Jul 2016 10:34:00 +0000

Default legends often put a lot of effort on the chart reader. Consider how you can improve the readability of your charts so that your readers don't struggle to interpret them. One solution can be replacing the default legend with dynamic series labels.

The post Excel Charts: Dynamic Line Series Labels appeared first on Xelplus - Leila Gharani.