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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You pointed me in the right direction. Turns out it is 255 characters - plus you gave me a workaround.
You Rock!