EXCEL ERROR - series formula is too long

[Guest]

Hi -

I am trying to create a bar chart and I can only plot so many values and
then I get the following error - series formula is too long.

I have tried adding more points by holding down the control key and then
clicking on the cells I want. After about 13 values (cells) the previous cell
addresses are deleted in the Source Data - Data Range box and the flashing
dotted line around the cells disappears.

Hope someone can help.

Bob

 

[Don Guillett]

try selecting the 1st cell>hold down the SHIFT key>select the last cell

 

[Debra Dalgleish]

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

If the cells are adjacent, drag over them to select them as one range.
If they're not adjacent, you could create a summary table on the
worksheet, linked to the discontiguous data, and create the chart from
that table.