A dynamic graph does not show all x-axis names

[haraslub]

Hello everyone,

I would kindly like to ask you for a help. I would like to create a dynamic graph. Once I do that, all data is in, but all x-axis names/labels do not appear. Anyone, who could help me, please?

Thank you very much in advance!

Regards
Luboš H.

 

[Domenic]

To define a dynamic range for both ChartDates and ChartValues, try...

=OFFSET(Sheet1!$A$2;0;0;COUNTA(Sheet1!$A:$A)-1;1)

and

=OFFSET(Sheet1!$B$2;0;0;COUNTA(Sheet1!$B:$B)-1;1)

Hope this helps!