If it's formula length the only work around is to reduce it's length.
This can be done by placing your chart data in a contiguous block.

If you want to email the file, off NG, I will take a look.
andy AT andypope DOT info

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
wrote in message
...
On 7 Jan, 15:08, Andy Pope wrote:
Hi,

Another limit is the series formula length, which is around 1024
characters.
This can be quickly exceeded if the chart is based on non-contiguous
ranges.

Cheers
Andy

wrote:
Does anyone know if there is a limit to the number of items you can
have on the x-axis of a chart in MS excel? Right now I am being
limited to 7 (e.g. when I try to add more than 7 values to my data
series, I am unable to so). Thanks!

--

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

hmmm. I do not think that I am violating any of the above rules/
limitations. Thoughts on how to circumvent this issue?