Hatched charts in Excel look beautiful. They look cool and professional. Hatching or shading between plotted lines enhances charts and helps to convey the story.

Creating hatched charts in Excel is rather easy (I’m using Excel 2013). For this illustration we will be using following set of data:

Hatched Charts in Excel

First hatched graph we will create for sales number only. Go to insert<Charts<Insert Area Charts. Insert the simple 2D area chart.

Hatched Charts in Excel

Now copy and paste the sales data into it. The graph will look like this.

Hatched Charts in Excel




Now format the axis label to include the years corresponding to the sales.

Hatched Charts in Excel

You can format the area as per your taste. Right click on the chart and click format data series. Go to fill and line and format it.

I personally like pattern fill, and my chart looks like this:

Hatched Charts in Excel

Now let’s copy this chart and paste below the original. In the duplicate chart, let’s add the profit numbers by copying and pasting it on the chart.

By slightly adjusting the pattern fill my chart look like this:

Hatched Charts in Excel

Now suppose I just want to shade or hatch the difference between the sales and profit. I can do this by doing white solid fill to the profit.

Now my chart looks like this.

Hatched Charts in Excel

Consider a case where we want to hatch the intersecting area between two series. Hatching such chart in Excel involves some tricks.

Let’s consider the following data:

Hatched Charts in Excel

Following the above process, my chart will look like this:

Hatched Charts in Excel

However, I just want to hatch the intersecting area and not all the areas. For this we need to insert another series into this chart which should follow the contour of the area we don’t want to be hatched.

I created another series called “Trick” for this purpose.

Hatched Charts in Excel

Copy and paste this data into the chart, and format this data series for solid white fill.

Now my graph look like this:

Hatched Charts in Excel

Hope you enjoyed this post on creating Hatched Charts in Excel. If you have any questions, let me know through the comment section below.

You can also download the Hatched Charts in Excel Workbook FREE!

Download Excelworkbook

 

Sign-up and Get Free Feasibility Reports

60 real-life feasibility study reports!