Can I have more than 255 characters in Chart "Values" of Excel 2k?

Basically put, when I'm trying to graph specific values from a very large and 
complex spreadsheet, I can't use all the cells I need to use because the X 
Values: and Y Values: are truncated at 255 characters.  Is there any sort of 
fix for this?
0
Benson (12)
7/8/2005 6:17:02 PM
excel.charting 18370 articles. 0 followers. Follow

3 Replies
763 Views

Similar Articles

[PageSpeed] 27

Excel has a specification limit of 255 data series in a chart
Not sure I could read with much more than 10!
-- 
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lloyd Benson" <Lloyd Benson@discussions.microsoft.com> wrote in message 
news:4E197374-9397-4B23-9F3C-9D79F75E04FB@microsoft.com...
> Basically put, when I'm trying to graph specific values from a very large 
> and
> complex spreadsheet, I can't use all the cells I need to use because the X
> Values: and Y Values: are truncated at 255 characters.  Is there any sort 
> of
> fix for this? 


0
bliengme5824 (3040)
7/8/2005 6:47:03 PM
Well, I'm only have 10 data series, but the values are spread out, so I have 
to pick and choose individual cells for points.  I can't sort because some 
data points are used in multiple series.  For example, my first few (out of 
over 400) values are:
LA, LB, MA, MC, MF, UA
LA, LB, MC, MD, UA, UB
LA, MA, MD, ME, MF
LB
LB
LB, MA, MC
LB, MA, MC, MD

So if I want to graph everything with MA, then I have to manually select the 
first, third, sixth, and seventh cells in a column.  This leads to the X 
Values and Y Values to look something like this:  
Sheet1!$T$3,Sheet1!$T$5,Sheet1!$T$8,Sheet1!$T$10:$T$11,Sheet1!$T$26:$T$31,Sheet1!$T$33,Sheet1!$T$36,Sheet1!$T$38,Sheet1!$T$54:$T$62,Sheet1!$T$69,Sheet1!$T$90:$T$93,Sheet1!$T$98:$T$104,Sheet1!$T$109,Sheet1!$T$117:$T$119,Sheet1!$T$122:$T$127,Sheet1!$T$131

And they get truncated before I'm done with values.  I did get around it by 
having multiple worksheets named: LA, LB, MA, MB, etc. but then if I change 
anything on the master sheet, I have to change it on other sheets, unless 
there is a way to dynamically link everything, which there probably is, but 
this is still becomming quite a headache.

"Bernard Liengme" wrote:

> Excel has a specification limit of 255 data series in a chart
> Not sure I could read with much more than 10!
> -- 
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
> 
> "Lloyd Benson" <Lloyd Benson@discussions.microsoft.com> wrote in message 
> news:4E197374-9397-4B23-9F3C-9D79F75E04FB@microsoft.com...
> > Basically put, when I'm trying to graph specific values from a very large 
> > and
> > complex spreadsheet, I can't use all the cells I need to use because the X
> > Values: and Y Values: are truncated at 255 characters.  Is there any sort 
> > of
> > fix for this? 
> 
> 
> 
0
7/8/2005 7:47:04 PM
The solution is to somehow construct a consolidation range which has the 
relevant data in a contiguous range of cells. Formulas, sorting, pivot 
tables, whatever. You might even need to make multiple copies of your 
source data, just to get out what you need.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Lloyd Benson wrote:

> Well, I'm only have 10 data series, but the values are spread out, so I have 
> to pick and choose individual cells for points.  I can't sort because some 
> data points are used in multiple series.  For example, my first few (out of 
> over 400) values are:
> LA, LB, MA, MC, MF, UA
> LA, LB, MC, MD, UA, UB
> LA, MA, MD, ME, MF
> LB
> LB
> LB, MA, MC
> LB, MA, MC, MD
> 
> So if I want to graph everything with MA, then I have to manually select the 
> first, third, sixth, and seventh cells in a column.  This leads to the X 
> Values and Y Values to look something like this:  
> Sheet1!$T$3,Sheet1!$T$5,Sheet1!$T$8,Sheet1!$T$10:$T$11,Sheet1!$T$26:$T$31,Sheet1!$T$33,Sheet1!$T$36,Sheet1!$T$38,Sheet1!$T$54:$T$62,Sheet1!$T$69,Sheet1!$T$90:$T$93,Sheet1!$T$98:$T$104,Sheet1!$T$109,Sheet1!$T$117:$T$119,Sheet1!$T$122:$T$127,Sheet1!$T$131
> 
> And they get truncated before I'm done with values.  I did get around it by 
> having multiple worksheets named: LA, LB, MA, MB, etc. but then if I change 
> anything on the master sheet, I have to change it on other sheets, unless 
> there is a way to dynamically link everything, which there probably is, but 
> this is still becomming quite a headache.
> 
> "Bernard Liengme" wrote:
> 
> 
>>Excel has a specification limit of 255 data series in a chart
>>Not sure I could read with much more than 10!
>>-- 
>>Bernard V Liengme
>>www.stfx.ca/people/bliengme
>>remove caps from email
>>
>>"Lloyd Benson" <Lloyd Benson@discussions.microsoft.com> wrote in message 
>>news:4E197374-9397-4B23-9F3C-9D79F75E04FB@microsoft.com...
>>
>>>Basically put, when I'm trying to graph specific values from a very large 
>>>and
>>>complex spreadsheet, I can't use all the cells I need to use because the X
>>>Values: and Y Values: are truncated at 255 characters.  Is there any sort 
>>>of
>>>fix for this? 
>>
>>
>>
0
7/8/2005 11:38:44 PM
Reply:

Similar Artilces:

Excel 2003/edit/replace. Under Options/Look In, values is AWOL bu.
Under Look In options Find allows for search by formulae OR values OR comments Replace is restricted to formulaes ONLY WHY? cp Have a look at this google search result. This topic came up a couple days ago and was addressed by Dave and Myrna. http://snipurl.com/cd9j Gord Dibben Excel MVP On Fri, 28 Jan 2005 03:49:02 -0800, "cp" <cp@discussions.microsoft.com> wrote: >Under Look In options >Find allows for search by formulae OR values OR comments >Replace is restricted to formulaes ONLY >WHY? ...

Paste Several Values into one Cell
Hi all. I have data in several cells (I2:GJ2) on one row. I want to copy all of this data into one cell as it appears now (in a particular sequence). Is this possible? Thx in advance. Not sure if this is what you want but to concatenate data from several cells into 1 cell, use formula =Concatenate(I2," ",H2," ",G2) just add more cell references with commas and " " to give a space between each cell value for all the cells you want. "sgarrett" <anonymous@discussions.microsoft.com> wrote in message news:110F5183-D1CE-4C5A-A7F8-90D01E500FBE@micr...

incremental counter for dup number values
my wife, accountant, is very often bringing home work where she wants to match offsetting records from two record sets by value only. However, where one set may have 10 instances of $25, the other may only have 2 instances of $25. How can I effectively limit the pick of only two records from the set with 10 dups? ...

sum values from range of cells if cells correcponding have the sam
hiya, i have a small project and i've spent too much time on this already - can't figure it out myself. What i need to do is to create a formula which will find the same values in column A and will sum the corresponding to them values from columns B:E. this is a sort of result i want to get: A B C D E F RESULT: 1 A1 1 5 2 3 A1 31 2 B5 2 6 3 3 A2 19 3 C1 3 7 4 3 B1 22 4 A1 4 8 5 3 B5 37 5 B5 5 9 6 3 C1 33 6 C2 6 1 6 3 C2 16 7 A2 7 2 7 3 8 B1 8 3 8 3 9 C1 9 4 0 3 I would appreciate any ideas how to do this. Thanks and regards, Assume in G1 down are the unique item...

FormView contained in an UpdatePanel always returns NULL values.
I have a formview that is fully contained within an UpdatePanel, and when the Update command is sent, the textboxes in my formview are always returning null values. If I read textboxes contained outside of the UpdatePanel, I am getting the actual values. I have tried getting the values on the InputParameters of my ObjectDataSource, as well as trying to read the values directly from the TextBoxes in the FormView, and they both contain NULL values. I have seen a few other posts from people having this problem, but I have yet to see a resolution. The code containing the UpdatePa...

how do i get mutiple values using vlookup in excel, lookup value .
hi , i have data stored in excel as column a- Purchase order no column b- Invoice no i want to query basis purchase order no & result should give mutiple invoice no stored agst one purchase order no how do i do this using lookup or something ! One way: Invoke AutoFilter. Abhijeet wrote: > hi , i have data stored in excel as column a- Purchase order no column b- > Invoice no i want to query basis purchase order no & result should give > mutiple invoice no stored agst one purchase order no how do i do this using > lookup or something ! I use the following for somet...

Variable chart Source Data Y Values
I can't seem to encode the Y-Values of a chart to have a variable range. (in Excel 2000) I have tried things like: ="INDIRECT( CONCATENATE( "Sheet1!$A$1:$A$", TEXT($B$1,"0") ) )" where $B$1 = 20. I had hoped this would produce (and evaluate) the formula "Sheet1$A $1:$A$20". Instead, I receive "That function is not valid". Does anyone know of a way to do this? The reason I ask is: I have a data series which keeps track of monthly values and estimates the future months' values. This is done using a formula in future month'...

Problems generating an html link based on worksheet values
I want to generate a hyper link based on text in a cell, for example the cells D16 and D17 generate the text strings in F16 and F17, which are valid filenames. I have two macros MakeLink_file MakeLink_datNum that should both generate hyperlinks for me (source for these below), however MakeLink_file does not work, whereas MakeLink_datNum does (I want to use the more generic MakeLink_file version). Any ideas why the simpler macro does not work? Fred D16 = 4383 D17 = 1267 F16 = \\FDR-server\General Pool\Beatrix\DATA SHEETS\FDR_PDF\4383 DAT 01.pdf F17 = \\FDR-server\General Pool\Beatrix\DA...

Getting values to show colors in chart
Hi, Excel has numerous charting options. However, I need to display a ma of a country and let certain parts change color according to value that are stored in a database. I can get the values in a normal graph but is it at all possible t make a custom chart (like a map) where I can get certain parts t correspond with the values? Thanks -- Message posted from http://www.ExcelForum.com I don't believe you can do what you want without programming support. Suppose you create a map of, say the U.S. Now, create a freeform shape that aligns with the boundary of each state. Finally, use a...

Values not showing
Stupid question really, but my spreadsheets are just displaying the formulae in the cells. How do I change them to just display values? It's so easy I can't see it! Regards Try Tools|Options|View tab|Uncheck Formulas Dennis Saunders wrote: > > Stupid question really, but my spreadsheets are just displaying the formulae > in the cells. How do I change them to just display values? > It's so easy I can't see it! > Regards -- Dave Peterson Hi Dave, tried that already...no joy. Dennis Ah, I think I've found it. Somehow my formulae (which have wor...

Unable to Programically Total Values
I have got a report where the records extend beyond the ranges of the report period. So if the report period is 3/1 - 3/31, you might have the following records in the report. Since we are only concerned about time frame that the records fall within the report, I am manipulating the report to adjust the Start or End that is DISPLAYED on the report ACTUAL RECORDS RecordId Start End 1001 2/25 3/15 1002 3/15 3/31 1003 3/25 4/25 RECORDS AS DISPLAYED RecordId Start End 1001 3/1 ...

Identifying missing numerical values in a series
In column A I have a series of numbers running from 1001 to 9078. These numbers run in numerical order, but there are known missing values. For example, the numbers may run 1000, 1001, 1005. In this instance the missing numbers are 1002, 1003 and 1004. It is these missing numbers that I need to identify from the column of numbers running from 1001 to 9078. Could these missing numbers be placed in column C. Any help would be greatly appreciated. Try the below array formula. This will be a bit slow...so try with a smaller range for testing as below..Please note that this is an...

Combing Cell Values
Hello, Need some help with combing cell values. I know that =value(a1&b1) example. Cell A1 = 1 Cell B1= 3 Output =13 But if A1 has a text value such as ABC, I get an error on output. With text and numeric, how do you combine? Thanks JR try leaving out value -- Don Guillett SalesAid Software donaldb@281.com "JR" <gaspower@nothing.sbcglobal.net> wrote in message news:mqWJb.5923$KV4.1988@newssvr29.news.prodigy.com... > Hello, > > Need some help with combing cell values. I know that =value(a1&b1) example. > > Cell A1 = 1 > Cell B1= 3 > > Ou...

converting text values to number & decimal values..
I have any array which read a csv file and I am using split and populate these fields into my table.. temp= 5245,test1,23.45 temp1=3456,test1,23.45 Now I want to convert my text fields to number and decimels respectively. I tried the following functions but this works fine if they are number and fails it was text value. TESTID = CInt(sampleid) 'CInt(myarray(1))Convert to number CT_num = CDec(ct_val) -- Message posted via http://www.accessmonster.com Hi, Test to see if they are numeric first. If IsNumeric(sampleid) Then TESTID = CInt(sampleid) Else ...

Insert spaces between pasted values #2
Hi! Is there a way to insert spaces between values that are pasted? For example, i have in rows 1,2,3 values a,b,c and i want to paste them into another list in rows 1,3,5 respectively (with a single-row space between pasted values). Thanx! M I presume you have more than just 3 rows. A general approach would be to use a helper column next to your data and to fill a simple sequence down that column for as much data as you have. Then copy all the numbers that make up that sequence and paste them immediately below the sequence in the same column, so that if you have 200 numbers for example the...

access compare values and select higher of two
In Access database I want to compare the values in two fields in a form and then select the higher value, insert it into another field and then use in a formula. E.g. Value 1 = 500 Value 2 = 600, 600 to be inserted into another field and then be multiplied. On 11 apr, 21:26, Captain Turtle <Captain Tur...@discussions.microsoft.com> wrote: > In Access database I want to compare the values in two fields in a form a= nd > then select the higher value, insert it into another field and then use i= n a > formula. > > E.g. Value 1 =3D 500 =A0 Value 2 =3D 60...

x axis not showing correct values
i have dates on my x axis, but for this graph i am not using all of it, e.g. it goes from monday to sunday but im only using monday to wednesday and friday to sunday, but it is showing the whole lot rather than what i have input. =('Rel. PE in progress'!$C$2:$CT$2,'Rel. PE in progress'!$DG$2:$DR$2) i am using this same formula for the values on the graph and they are showing up correctly. not sure why the difference thanks anyone Excel recognized the dates, and put a time scale axis on the chart. This means each day from first to last is represented, even if that day has ...

Tool to extract CRM JavaScript, picklist values, Attributes
Found it here by chance, excellent tool! http://www.codeplex.com/CRMDocumentation Follow the instructions there. Excellent tool to extract CRM JavaScript, picklist values, Attributes to generate documentation or, in my case, test cases based on customizations. HTH, Mohamed ...

Trying to include all values from 2 tables in Select Query - even where there is no match
I am pulling from a database (that is in very poor shape) trying to determine weekly hours out of a project accounting system with little luck. The problem is, I'm pulling each Friday and then have to subtract YTD Hours from Week 1 out of Week 2 (Current YTD - Previous YTD). The fields I have to work with are Name, Cost Center, and Cost Center Type. In my query I concatenate these values to create a unique field, so that I can link the tables together. Where I run into problems, I have 3 options...Show where they are the same, Show only from table 1, or show only from table 2. Often w...

issuing numbers to values
i need some help with creating a list of numbers to use as reference numbers i have 4 columns, the first is the quantity of the item to be made, second is the work order number(the value i want generated), third is the description and the last is the quantity made. i have a list of 200 items and only about 120 or so each week are made each week, but i need to show all items. it starts at where the last number left of and it needs to run consecutivly but not showing numbers in between. i have this formula so far if you can modify it to not show the result in the cel =IF(A2>0,B2+1,IF(A2<...

values 'inside 'base' in a bar chart
I am having problems using the 'inside base' for showing values when I copy a chart from Excel and put it in Powerpoint. The values look centered in Excel but when I look at the slide show, the values have shifted to the left of center. Does anyone have any suggestions? I experimented in versions 2003 and 2007 and it happens in both. Thanks for any help you can give. Is is a horizontal bar chart? Inside Base means inside the bar at the end closest to zero, so probably closest to the right. If the labels and bars are of certain sizes, they might look centered, then after the...

splitting cell values
I have a cell value with something like this: 5830 Paradise Bay - wall or Hickory Woods 26 - footing I need to divide these into two columns separated by the dash. So the address will go in one column and the other term (wall, footing, etc) will go into another. Any ideas? Thanks, Diane Make sure the column to the right is empty, if not select the column to the right, right click the header and select insert, now select the column with the text you want split, do data>text to columns, select delimited, click next, check other and put in a dash there, click finish -- Regar...

Adding comma seperated values within a single cell
I need to come up with a custom function that will add up comma seperated numerals contained within a single cell. For example if the the cell A1 contains: 4,5,3 I want the result of the fuction (say in a2) to display the result of 12 Any help greatly appreciated. Regards Mike On Tue, 07 Oct 2008 20:39:01 +1100, Michael Toal <M.Toal@bom.gov.au> wrote: >I need to come up with a custom function that will add up comma seperated >numerals contained within a single cell. > >For example if the the cell A1 contains: > >4,5,3 > >I want the result of the fuction (sa...

List of different values in data area
Hi excel specialists, How Can I automatically get the list of different values from the dat area and to find out their frequence? INDIVIDUALLY MEASURED VALUES: 3,5 4 3,5 4 3 3,5 4 4 3 3,5 4 3 3,5 3 3 3,5 4 4 Thanks for your help in advance. Balcovja -- balcovj ----------------------------------------------------------------------- balcovja's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2623 View this thread: http://www.excelforum.com/showthread.php?threadid=39572 Take a look at FREQUENCY in Hep -- HTH RP (remove nothere from the email address if m...

Why are the values in my report bound to each other?
I created a report based on a cross-tab query using the wizard. It is handy in many ways, including keeping the values evenly spaced in each row and changing their horizontal order in the row by using the left and right arrow buttons. But can I turn off this feature? I want to insert a manually-created sub-total of the first 3 values, and it won't let me insert that manual sub-total between the 3rd and 4th values, because I can't create a wider space between any of the values. I don't see any different properties in these values and the manually-created values. ...