Excel Only Lets me put 11 items in a chart!

  • Thread starter Thread starter Josh
  • Start date Start date
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
 
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.
 
Back
Top