Sparklines are not working Excel 2010

I am trying to use "sparklines" in  Excel 2010.  I have my data formated like this:
Year                        
Account      Description      2009      2010      2011
6001      Salary                      28608      32120      31416
6002      OT                      614      427      1940
6370      Depr Building      1708      1708      1708
6371      Repairs                      0      304      103
6372      Utilities                      0      0      0
6373      Rental                      6600      7150      6600
6374      R.E. Tax                      0      0      0
6428      Depr Equip      8715      8715      8907

The dollar amounts are formatted as "Number" with no decimal points.  I use some add-ons in my excel, howerver, I have tried this using starting excel with the excel /s switch and it does not help.

When I go to insert a sparkline, It tells me either "location reference is not valid" or "data source reference is not valid" depending on which I fill in first.  I have watched multiple tutorials and am doing the same thing that they are and it still comes up with the error.

I am trying to place it next to the 31416 value using the three numbers in that row as the data range.

Any help would be appreciated. ( Numbers are line up properly in the worksheet, they don't translate well to the question area I guess)
mobankerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

als315Commented:
Look at exmple
Sparclines.xlsx
0
mobankerAuthor Commented:
It comes through great and I can see the sparklines.  I deleted one cell and could copy down.  However, it still won't create one.  Beginning to wonder if I have an installation issue.
0
als315Commented:
Can you upload your file (or my file with your modifications) for testing?
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

mobankerAuthor Commented:
It would appear that the location portion is the problem in my working.  I accidently made it work.  The solution happen when I changed $F$2 to F2.  I don't quite understand why that worked.  The default when you click on a cell is to put the $ in the reference. Is that normal?

Thank you.
0
als315Commented:
$ means absolute reference. In your case it is wrong. When you copy cells up or down, $ reference remains unchanged and you always get same value in different cells.
0
mobankerAuthor Commented:
Thank you als315.  So is my installation working differently from others?  When I look at training videos like this one: http://www.youtube.com/watch?v=iNrhjFixC28  (about the 1:20 mark) it shows the program including the $h$2 automatically and excel accepting it.  Why would mine need the h2 reference instead?

Thank you
0
als315Commented:
Yes, use h2 (when you copy it down, it will be changed to h3, etc. $h$2 will not be changed).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mobankerAuthor Commented:
Thank you for your help!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.