Chart ignoring whole row when first cell is blank

[Reillob]

Hello everyone,

I have a code that generate a chart based on data. Nothing exotic here.
But whenever the very first cell of my data is empty, my chart will not include the first row.

I would like it to include the first row's data and leave a blank in the chart like its done for any other blank cell.

I don't want to set that value to zero because it would not make sense for my analysis.

Here is the code I am talking about :

Please Login or Register  to view this content.

The problem occurs at the parts that generate a chart only and if only the very first cell of my range is empty.

I hope this is clear enough, I would be happy to give more information if this is not.

Thank you.
Regards.

[Reillob]

No one can help ?

I really can't find a solution, I've tried things to get more information :

It only depends on the first cells of the first column.

If the first cell is not blank, everything is okay. If it is blank, my chart will ignore the first row and first column.
If the two first cells of the first column are blank, my chart will ignore the first row and the two first columns etc.
If the first cell is not blank but the second is (all that in the first column) then everything is okay.
Nothing happens when the first cell of the second column is empty, it all depends on the really first one.
But as you can see in my code, my range's first cell is supposed to be (1,1) no matter what so I really don't get it and can't find a way to solve that.

Need your help guys,
Thank you.

Edit : here is a picture of how things goes :

New.gif

As you can imagine, I would like that my chart consider everything even the blanks and I want it to leave a blank on the chart too.