Solved

Sparklines are not working Excel 2010

Posted on 2012-04-06
8
3,081 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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 500 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

856 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