Re: Chart Y-axis definition. Limitation for Maximum characters ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jon Peltier (DOjonNOTxlmvp_at_SPAMpeltiertechME.com)
Date: 08/04/04 

Date: Wed, 04 Aug 2004 00:14:18 -0400

Hari -

> Hence my doubt is whether there is a limit to maximum characters in
> the chart defining range which caused this problem..

That's exactly what the issue is. The series formula itself is allowed
1024 characters, but each of the four parts (name, x values, y values,
and plot order) are only allotted something less than 256 characters (a
waste, since plot order can never exceed 3 characters plus the comma
before it).

The workaround is to set aside a contiguous worksheet range that links
to the scattered cells in the worksheet.

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

Hari wrote:

> Hi,
>
> I encountered a strange problem (I believe every problem poser must be
> saying so.....)
>
> I was defining the range of y axis value in a Chart. The cells used in
> ranges were not together and hence in disparate places.
>
> So with Ctrl pressed I would select the cells I want. This way the name of
> the worksheet was also coming in the chart defining range. I had around 8
> data points and hence 8 different cells.
>
> Now when selecting the cells one by one when I got to the 7th one Excel
> wasnt selecting it. I mean I used to select it and then put a comma and then
> click on the 7th cell and again a comma and then the 8th ( and the final
> datapoint) cell.
>
> After this I went to some other data series and added some new ranges.
>
> When I went to my original data series I saw that though I had specified 8
> data points it wasnt specifying those 8 properly. I think one data point it
> was skipping and there was no comma between 6th and 7th. I redid this
> series taking care that all the 8 were specified properly. but after working
> on some other chart aspects when I went to his series again the same problem
> was cropping up.
>
> I struggled with this for couple more times and then thought that may be the
> space where we define the Y axis range for chart has a Maximum specification
> for number of characters.
>
> I then went back to the sheet and changed the name of the worksheet to a
> small one.(The name of the worksheet was actually quite big initially -->
> might be having 28 or 29 characters including spacebar) Now, when I built
> my chart I could do it without any problem.
>
> Hence my doubt is whether there is a limit to maximum characters in the
> chart defining range which caused this problem..
>
> Regards,
> Hari
> India
>
>

Relevant Pages

  • Re: Excel VBA Vs Chart Data Tables
    ... efficient using cells. ... there is a limit to how many characters can ... characters (maximum 255 series in a chart), and the Series Name argument is ... Worksheet space is cheap. ...
    (microsoft.public.excel.programming)
  • Chart Y-axis definition. Limitation for Maximum characters ?
    ... I was defining the range of y axis value in a Chart. ... So with Ctrl pressed I would select the cells I want. ... the worksheet was also coming in the chart defining range. ... data points it wasnt specifying those 8 properly. ...
    (microsoft.public.excel.misc)
  • Re: Remove non-printing characters
    ... I was hoping to do this without specifying the characters to ... Just to empty any cells ...
    (microsoft.public.excel.programming)
  • Re: Data Trucated in word merge with excel source
    ... If the "copy the sheet into Word and use ... If it did, I would try recreating my Excel sheet from scratch, ... that you probably have some cells in the "truncated" column that just ... the cells in excel has data over 255 characters long. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Import to Excel resulting in hash marks and chinese looking ch
    ... The cells are holding more than the 255, ... display 2) getting the text to display correctly ie: the chinese characters. ... back to Access though and need it to be of text data type for my Memo field ...
    (microsoft.public.access.externaldata)