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.
Crating Hatched Charts in Excel
Creating hatched charts in Excel is rather easy (I'm using Excel 2013). For this illustration we will be using the following set of data:
First hatched graph we will create for sales number only. Go to insert<Charts<Insert Area Charts. Insert the simple 2D area chart.
Now copy and paste the sales data into it. The graph will look like this.
Now format the axis label to include the years corresponding to the sales.
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:
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 them on the chart.
By slightly adjusting the pattern fill my chart look like this:
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.
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:
Following the above process, my chart will look like this:
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.
Copy and paste this data into the chart, and format this data series for solid white fill.
Now my graph looks like this:
Hope you enjoyed this post on creating Hatched Charts in Excel. If you have any questions, let me know in the comment section below.
You can also download the Hatched Charts in Excel Workbook FREE!
Check out more useful articles on Our Blog Page
Are you someone involved with
real estate feasibility?
We are excited to launch the next generation of real estate feasibility software to help you manage your development projects with ease.
Register now for a free trail license!