How to add % difference in dual trend lines

**sailor64** · 08-26-2009, 05:20 PM

Hey Guys
I am preparing two trend lines in one chart. For ex Say $ (Y axis) for client A in Q1, Q2, Q3 and Q4 (X axis) as one line and same metrics for Client B.

Is there a way to automatically show the % difference between the two clients for a given X axis value

So ideally we should have two lines and a % line connecting A and B showing how much Client A is higher than Client B in (say) Q1, Q2 etc

Thanks much
Cheers

**Andy Pope** · 08-27-2009, 05:26 AM

Is this the sort of thing you mean?
http://www.andypope.info/charts/Hilolabel.htm

Also when you say 'trend lines' do you mean period on period or a equational trend line?

**sailor64** · 08-27-2009, 02:38 PM

This is exactly the type of thing that I was talking about. Yes. When I said trend line I meant the line that connects one point to another that is all.

Thanks a lot Andy!
Cheers

Thread: How to add % difference in dual trend lines

Thread Tools

Display

How to add % difference in dual trend lines

Re: How to add % difference in dual trend lines

Re: How to add % difference in dual trend lines

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions