Solved

Excel - Chart Reference not valid

Posted on 2001-09-04
2
218 Views
Last Modified: 2012-08-13
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.
0
Comment
Question by:nnaxor
2 Comments
 
LVL 6

Accepted Solution

by:
bkpchs237 earned 100 total points
Comment Utility
nnaxor,

There is a limit to the number of characters that Excel will accept in the values area.  I don't recall off-hand what the exact number is, nor do I have a reference for you at the moment.  If you like, I could search for it.  Remember if you use cells from a different sheet, the sheet name is included in the values cell location on the source data tab.  That is why the program wipes out your data.

To get around this use named ranges.  To streamline it best, create the named range from the sheet that the chart is located.  Then you will have reduced the values area down to its smallest number of characters and still be able to place the data as desired onto your chart.

Hope this helps.
0
 
LVL 1

Author Comment

by:nnaxor
Comment Utility
Thanks bkpchs237!

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

You Rock!
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Introduction It seems that at least a couple of times per month, I answer a question that requires automating Outlook from another Microsoft Office application, usually (although not always) to send one or more email messages.  For example: …
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
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…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

743 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now