5 Replies Latest reply on Dec 2, 2016 3:27 PM by D Barnetson

# Line Chart - Shading the inside difference

Hi Guys,

I have two line which are the "Actual" and "Target".

I want to shade the difference between the two.

Can you help me with this.

Thanks,

• ###### 1. Re: Line Chart - Shading the inside difference

Hi Mac,

Hope this helps

Don

• ###### 2. Re: Line Chart - Shading the inside difference

Hi Don,

There is a little different on what I'm working on.

I'm using a string (Work Week Number which literally type in work week number, so if I convert it to date it will not produce any dates.)

Is there any way to to this?

Thanks,

• ###### 3. Re: Line Chart - Shading the inside difference

I think there's a good chance that we can make it work with what you have.

Are you able to attach a packaged workbook, some sample data, or even an image to give us a better idea of the data set that you're working with?

Don

• ###### 4. Re: Line Chart - Shading the inside difference

Hi Don,

Sorry I can't give you the workbook, but I can give a sample data:

e.g.

WW          Actual          Target

44               2                  1.5

45               3                  3.5

46              10                 12.5

47               5                    9

Thanks,

• ###### 5. Re: Line Chart - Shading the inside difference

Hi Mac,

I've found another technique that might work for you, but it's not perfect.

Shading between two lines - Line graph

Here's what it would look like with your data set + the extra weeks that I had added:

The link from my previous post seems to have the best results, so far, (still hunting for a better answer) if you have a full set of weeks.

4 weeks looks odd:

So, I've added a number of weeks to the sample data and it looks much closer:

I finally found what I was looking for . I knew someone would have come up with the right answer!

Here is the link that I derived my example from:

Fill the color betwen two lines

The key is to add a measure to produce the 'White' space to the mix using this calculation...(double click on the color for with and use this html code for white #fffff

MIN(SUM([Target]),SUM([Actual]))

...and to turn 'Stacked Marks' off, which can be found under the 'Analysis' tab.

I've attached a packaged workbook for you to review.