software

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: www.excelforum.com/member.php...oamp;userid=28673
View this thread: www.excelforum.com/showthread...hreadid=494074This is a case where the appropriate data layout will save you much
frustration. Either set up the data so you don't need to skip cells within
the chart source data, or explain what this means, so we can make an
alternative suggestion:

gt; Note: I have created chart dynamically. I cannot use like this format:
gt;
gt; =Data2!$F$9:$F$35

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______
quot;ramkumar_cptquot; gt;
wrote in message
news:ramkumar_cpt.204lna_1134724801.6171@excelforu m-nospam.com...
gt;
gt; Hi,
gt;
gt; I have one bar chart. I could not able to store the lengthy
gt; values in series collection.
gt;
gt; Because Series collection text box could accept limitted
gt; characters only. How to Store the lengthiest value in to series
gt; collection like this?
gt;
gt; (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)
gt;
gt; Note: I have created chart dynamically. I cannot use like this format:
gt;
gt; =Data2!$F$9:$F$35
gt;
gt; pls help.
gt;
gt; Thanks,
gt; Ram..
gt;
gt;
gt; --
gt; ramkumar_cpt
gt; ------------------------------------------------------------------------
gt; ramkumar_cpt's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28673
gt; View this thread: www.excelforum.com/showthread...hreadid=494074
gt;