Dynamic chart ranges based on formula- Issue on labels

[james444]

Hello,
i am creating a chart where starting date and corresponding value changes depending upon country. To do that i have defined two labels "Chart_Values" and "Chart_labels". These are created using offset formula in table where data is retrieved. Everything works fine but format of x axis label is weired.
PLease find attached the file.
Need help urgently

Regards
Kunal

[JohnTopley]

Go into Chart Tools (click on chart): Select Data==>Horizontal Axis ==> Edit and the select the Row 4 dates (K4 to AO4 ???)

[gmr4evr1]

My thoughts, and I could be wrong, but going by the workbook that OP attached, the Horizontal Axis should be

Please Login or Register  to view this content.

For the dates. The vertical should be

Please Login or Register  to view this content.

James444 Chart Range.xlsx

[james444]

sorry guys...earlier file attached was not showing functionality of dynamic charts...please find updated file... earlier provided solution doesnt work in this case

[TMS]

Chart_Labels:

Please Login or Register  to view this content.

Regards, TMS

[gmr4evr1]

Dang it, so much simpler than what I was doing.

[Andy Pope]

I removed the + from the values named formula and it worked as is.
Chart_Values: =OFFSET('Adoption curves'!$AS$4,1,0,COUNT('Adoption curves'!$AS$5:$AS$40),1)

[james444]

thanks everyone...issue has been resolved