Excel - Chart Reference not valid
Posted on 2001-09-04
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.