Run Time error 438 - using Rows.Count

Hello.
I am exporting a query to MS Excel and this time,I am trying to edit an xlBarStacked Chart from MS Access without using Excel as a reference.

This part of my code works fine:

Please Login or Register  to view this content.

Looking for to set min and max date for axis values into x axis, I add the following code:

Please Login or Register  to view this content.

When I run Debug->Compile from the VB Editor's main menu, there is no alert about any recognized names.
However, when I execute the code from Access Button, I get an error here:

Please Login or Register  to view this content.

I've tried numerous different ways of fixing this problem, such as rewriting the line, changing sheet names. I have been googling and I can't seem to find any documentation on this scenario.

I'd really appreciate any help.

Hello.
Thanks for your reply.
With the dot I tried two lines of code

With this code:

Please Login or Register  to view this content.

This message is displayed:

Please Login or Register  to view this content.

With this code:

This message is displayed:

Please Login or Register  to view this content.

Could you advise me, how to fix such errors?

Please. Can you tell me what you mean with:
"Without the workbook, it's a longshot"..

Thank you for your reply.

I don't know, I am using MS Access 2016 and MS Excel 2016.

When I executed the code by the first time I used:

Please Login or Register  to view this content.

Then, I used:

Please Login or Register  to view this content.

Every time VBA displays error messages.

I have to tell you that to write this code I recorded a macro in Excel.
Then, I refined the code trying to adapt it to VBA for MS Access.

All code works fine, except the lines under analysis.

I appreciate your help

Cheers

Hello.
When I type the code to see the IntelliSense,

Please Login or Register  to view this content.

The above code line is coloured red and "A" is coloured in blue.
I have no idea how to fix the error.

Thanks

Hello

This code works

Please Login or Register  to view this content.

See the (,) instead of (.)

But codes:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Displays:
Error 438 "object doesn't support this property or method.

I have no idea on how to fix the error 438.

Cheers

Thanks.
I attach the workbook with the Chart I need to create form MS Access.
Also, the code is included.
Cheers

Hello.

I adjusted the code and got now an error againg:

Please Login or Register  to view this content.

VBA displays here:

Please Login or Register  to view this content.

I understand Error number 1004 means: "Look, I can't find what you are looking for".

I am looking for:

Please Login or Register  to view this content.

Since this morning I have tried googling in all types of VBA Forums for the solution, but I have not found it and I can't figure it out.
That's why I posted again.

Any help would be very much appreciated.
Cheers

protonLeah. Hello

With items 1 and 2 I am in complete agreement.
With point 2, I was testing many code lines and I tried to save queries with different name trying to keep code traceability.

The code you send to me is the last and most important link in my project.

Thank you very much indeed.

Cheers

Thanks to protonLeah and Tsjallie for your help.