?
Solved

Sparklines are not working Excel 2010

Posted on 2012-04-06
8
Medium Priority
?
4,559 Views
Last Modified: 2012-04-09
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)
0
Comment
Question by:mobanker
  • 4
  • 4
8 Comments
 
LVL 41

Expert Comment

by:als315
ID: 37818538
Look at exmple
Sparclines.xlsx
0
 

Author Comment

by:mobanker
ID: 37818953
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
 
LVL 41

Expert Comment

by:als315
ID: 37818965
Can you upload your file (or my file with your modifications) for testing?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 

Author Comment

by:mobanker
ID: 37820283
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
 
LVL 41

Expert Comment

by:als315
ID: 37820649
$ 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
 

Author Comment

by:mobanker
ID: 37823209
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
 
LVL 41

Accepted Solution

by:
als315 earned 1000 total points
ID: 37823352
Yes, use h2 (when you copy it down, it will be changed to h3, etc. $h$2 will not be changed).
0
 

Author Closing Comment

by:mobanker
ID: 37824500
Thank you for your help!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This tutorial is about creating a new Microsoft Online User Profile account along with how to transfer your files and settings. You may be faced with this situation if your existing user profile has become corrupted.
While repairing a PST file with ScanPST.exe, many users have encountered the error "Attempting to Validate BBT Refcounts". In this article, we are going to describe the reasons and solution to fix the error.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question