Hi,

I have one bar chart. I could not able to store the lengthy
values in series collection.

Because Series collection text box could accept limitted
characters only. How to Store the lengthiest value in to series
collection like this?

(Data2!$F$3,Data2!$F$5,Data2!$F$9,Data2!$F$11,Data 2!$F$14,Data2!$F$15,Data2!$F$16,Data2!$F$19,Data2! $F$20,Data2!$F$21,Data2!$F$22,Data2!$F$23,Data2!$F $24,Data2!$F$25,Data2!$F$36,Data2!$F$37,Data2!$F$3 8,Data2!$F$39,Data2!$F$40,Data2!$F$41,Data2!$F$42, Data2!$F$43,Data2!$F$44,Data2!$F$45,Data2!$F$46,Da ta2!$F$47,Data2!$F$48,Data2!$F$49,Data2!$F$50)

Note: I have created chart dynamically. I cannot use like this format:

=Data2!$F$9:$F$35

pls help.

Thanks,
Ram..


--
ramkumar_cpt
------------------------------------------------------------------------
ramkumar_cpt's Profile: http://www.excelforum.com/member.php...o&userid=28673
View this thread: http://www.excelforum.com/showthread...hreadid=494074