Sparklines error

[thunderbird]

Hi,

I'm using Excel 2010 and am trying to insert the "Line" sparkline. My Data (numbers) is in the range "C2:G25" and I'm trying to insert the sparkline in column B (range "B2:B25")

In the dialogue box, I enter C2:G25 in the "Data Range" and $B$2:$B$25 in the "Location Range" however, I get an error saying "Location reference is not valid."

Any ideas on what I might be doing wrong?

 

[AhoyNC]

Hi,

I'm using Excel 2010 and am trying to insert the "Line" sparkline. My Data (numbers) is in the range "C2:G25" and I'm trying to insert the sparkline in column B (range "B2:B25")

In the dialogue box, I enter C2:G25 in the "Data Range" and $B$2:$B$25 in the "Location Range" however, I get an error saying "Location reference is not valid."

Any ideas on what I might be doing wrong?

Make sure that all the cells in B2:B25 are empty. If you hit the space bar and put a space (which you will not see) into one of the cells you will get this error.
I would highlight the cells B2:B25 and press "delete key" then try to add the sparkline.

 

[thunderbird]

Nope, tried that too. Same error!