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?
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?
Sorry I can't give you the workbook, but I can give a sample data:
WW Actual Target
44 2 1.5
45 3 3.5
46 10 12.5
47 5 9
I've found another technique that might work for you, but it's not perfect.
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:
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
...and to turn 'Stacked Marks' off, which can be found under the 'Analysis' tab.
I've attached a packaged workbook for you to review.
Hope this makes your day, because it has made mine .
Shade Between Lines.twbx 8.3 KB