Showing part of Excel trend line in other diagram
December 4, 2014
I don’t consider myself a Excel expert user but recently I’ve started to use it more and more and both come to like it and start doing some pretty advanced stuff with it. As always this kind of knowledge cannot be had in faked, training environment - for me it has to be something real to stick.
We have quite a lot of data for one of our hospitals that we now can get some pretty good trends from. But when I wanted to show only part of the trend line on a diagram showing part of the data … I ran into problem with the default, tooling suggested, ways of doing things.
I had do it myself a little bit, and try to extract some Math-skills from way back when. Luckily I had good help around me…
In this post I’ll show you what we did to get part...