Formula/Approach Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to come up with a way to determine if my RegionSales are growing
relative to my overall National Sales.

My data looks like this:

Date Region National
20071101 1021 172567
20071102 721 186299
20071105 285 155710
20071106 82 105716
20071107 157 131404
20071108 20 171816
20071109 1002 143059

Thank you in advance.
 
Why not add a ratio column, with a formula of

=B2/C2

formatted as percentage, and graph column D over column A.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top