ValueBox limitation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a XY Diagram. Within the ValueBox you can type a range of cells or selecting them by clicking on the CollapseDialogButton

It seems that Excel 2002 (ServicePack2 already installed) has a 255 character limitaion. Because as I tryed to type or selecting cells on a worksheet I got
limitation if I choosed more than the 255 characters which are shown in the valueBox

Does anybody know a workaround for this kind of Problem
 
You could link all the named cells to a range of contiguous cells, then
create the chart from that range.

Or, select all the cells, and give this range a name. Type that name in
the data range box when you create the chart.
 
Back
Top