Excel Only Lets me put 11 items in a chart!

J

Josh

I tried to only put 12 items in a chart for at least 2
hours put Excel only lets me put in 11 items!! Please
help! I don't get it because word will let me put at
least 12 and more!! I've reimstalled Excel and download
all updates and it still doesn't work!

-Josh
 
D

Debra Dalgleish

There's a limit to the number of characters that you can enter in the
Data Range box.

As a workaround, you could define the range of cells that you want to
use, and enter the range name in the Data Range box. There are some
instructions here for creating a named range:

http://www.contextures.com/xlNames01.html

Or, create a summary table on the worksheet, linked to the data, and
create the chart from that table.
 
Top