Dynamic chart range not displaying all Horizontal Axis Labels

[Peter Davison]

I have created a chart from data in Cells DR5 to DY7 - Although the DY7 could be more columns which is why I am trying to make it dynamic (see below)
I am using this Named Range called - Numberofstores
=IFERROR(OFFSET(Assortment!$DR$5:$EZ$7,0,0,3,COUNT(Assortment!$DR$5:$EZ$5)*1),"")
but as you can see it is still only displaying the one line (Row 5).
I don't think I have the named range formula correct.
Any help would be appreciated.

 

[Peter Davison]

This automatic macro is on a different sheet, that shouldn't be a problem should it?
There are no other macros on this workbook.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.EntireColumn.AutoFit
End Sub

 

[Peter Davison]

I'm just going into a meeting now so I'll have a look first thing in the morning to see if I can just use the bit for the chart on a different file?

 

[RoryA]

Autofitting column widths shouldn't make any difference.

 

[Peter Davison]

It looks like I have cracked it.
I re-created the data into a new position and it worked, no idea why it wouldn't work before.
So all good.
And...
Again thanks for all your help.

Regards

 

[RoryA]

You've gotta love a solution that works but makes no sense. Glad it's fixed.