Sparklines are not working Excel 2010

Posted on 2012-04-06
Last Modified: 2012-04-09
I am trying to use "sparklines" in  Excel 2010.  I have my data formated like this:
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)
Question by:mobanker
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
LVL 40

Expert Comment

ID: 37818538
Look at exmple

Author Comment

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.
LVL 40

Expert Comment

ID: 37818965
Can you upload your file (or my file with your modifications) for testing?
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.


Author Comment

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.
LVL 40

Expert Comment

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.

Author Comment

ID: 37823209
Thank you als315.  So is my installation working differently from others?  When I look at training videos like this one:  (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
LVL 40

Accepted Solution

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).

Author Closing Comment

ID: 37824500
Thank you for your help!

Featured Post

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!

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

726 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