Link to home
Start Free TrialLog in
Avatar of nnaxor
nnaxor

asked on

Excel - Chart Reference not valid

Hello there.  I have an interesting question and actually I am not sure that I can adequately describe the problem but I shall try.

I have a user and on one of the worksheets it is all Charts.  When right clicking the chart and choosing Source Data --> Series and then clicking in the Values field, I go to the worksheet that has the values and begin clicking, and ctrl clicking to select the data I want to use as values.  It will let me choose 6 cells and on the 7th cell it whites out everything I had chosen before, erases it so to speak.

On another chart we have 7 cells as values.

Does this sound familiar to anyone?

Thanks in advance.
ASKER CERTIFIED SOLUTION
Avatar of bkpchs237
bkpchs237

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of nnaxor
nnaxor

ASKER

Thanks bkpchs237!

You pointed me in the right direction.  Turns out it is 255 characters - plus you gave me a workaround.  

You Rock!