Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel - Chart Reference not valid

Posted on 2001-09-04
2
Medium Priority
?
227 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 400 total points
ID: 6455284
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
ID: 6457446
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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

783 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