Can't choose more than 9 values in Excel Graph

[ryanc2]

I'm trying to create a line chart in Excel using Month as the X axis (13 months) and sales dollars as the Y. I'm adding the first series from my worksheet, and it won't let me select more than nine values for that series. I'm starting at January using ctrl to select multiple values and once I select the 10th cell, it gives the error beep and clears my selection.

Any help would be appreciated as I'm banging my head against the wall to create a simple trend graph.

Thanks

 

[AndyPope]

There is a maximum length to the range reference, possible 255 characters.
If you are using non contiguous ranges then its quite easy to reach this limit as the sheet name will be repeated.

Select some of the data and then use the Source Data dialog to Add the rest of the data series.

Or if you can re arrange your data in to a single block.

Cheers
Andy

 

[KenWright]

Andy - Is that you??

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[AndyPope]

Hi Ken,

Yes its me. Just doing one of my flyby posts

Cheers
Andy

 

[KenWright]

Welcome

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[AndyPope]

Thanks Ken.