Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Sparklines are not working Excel 2010

Posted on 2012-04-06
8
Medium Priority
?
4,203 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 40

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 40

Expert Comment

by:als315
ID: 37818965
Can you upload your file (or my file with your modifications) for testing?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 40

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 40

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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
MS Outlook undoubtedly is the most widely used email client.Its user-friendliness, cost effectiveness, and availability with Microsoft Office Suite make it the most popular email application.  Its compatibility with Microsoft applications like Exch…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

579 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