Category x axis labels not displaying

I have graphs (see attached) and the months April to September are supposed to appear but only April does? why is this? This is unfuriatingly irrititating!

Hi
check your X axis labels - they should be corrected here

edvwvw

Originally Posted by edvwvw

Hi
check your X axis labels - they should be corrected here

edvwvw

hi - tried adding September in the top left graph (no. of stroke admissions) and it results in just April appearing again

Originally Posted by Andy Pope

The data points are picked from a non contiguous range where as the axis labels are taken from a contigous range.

=SERIES('Monthly data '!$I$2,
'Monthly data '!$I$1:$CB$1,
('Monthly data '!$J$11,'Monthly data '!$V$11,'Monthly data '!$AH$11,'Monthly data '!$AT$11,'Monthly data '!$BF$11,'Monthly data '!$BR$11),
1)

So the first six cells of I1:CB1 are used.

hi - so what is the fix?

Not sure of the most efficient and timely way to fix this guys - as you can see if i have alot of columns in the data table with Denominator, numerator and % for each organisation and there are 3 of them. The graph itself just has to show the percentage though

it seems pretty ridiculous that you cannot reference category x axis labels non contiguously - where is the logic behind that?

Originally Posted by Andy Pope

Who said that?

I showed you what the formula would look like when using non contiguous ranges.

The limit is on formula length.

The solution and sensible approach is to layout your charting data in such a way that is suitable for charting.

my apologies - just getting frustrated and letting some steam out. you are right.
So there is a 1024 char limit on formula length yes?

Originally Posted by Andy Pope

Correct. So what you have in the example will work but going forward more additional periods will cause you problems.

so the aim is then to have the category axis and the data as contiguous items