Excel Bar Graph
 

I am creating a simple bar chart and can't get past 14 data points using the
Control click method of selecting data points. Trying to type in the data
point does not help. Any Ideas would be appreciated.

Excel Bar Graph
 

Hi,

There is a limit to the length of the series formula.
Using non consecutive cells vastly increased the length of that formula.

Here is an example, firstly plotting the range A1:B10

=SERIES(,Sheet1!$A$1:$A$10,Sheet1!$B$1:$B$10,1)

Now plotting only the even rows. So less data points but the series
formula length is 90 characters longer.
=SERIES(,(Sheet1!$A$2,Sheet1!$A$4,Sheet1!$A$6,Shee t1!$A$8,Sheet1!$A$10),(Sheet1!$B$2,Sheet1!$B$4,She et1!$B$6,Sheet1!$B$8,Sheet1!$B$10),1)

Simplest way is to use consecutive cells and formula to build a set of
charting data.

Cheers
Andy

Cyberguy wrote:
I am creating a simple bar chart and can't get past 14 data points using the
Control click method of selecting data points. Trying to type in the data
point does not help. Any Ideas would be appreciated.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info