Dynamic graph plot automatically extending the x axis

**FilipeF** · 11-26-2018, 10:15 AM

hi all,

I've a macro to plot graphs from a dynamic table:

Please Login or Register  to view this content.

It's working perfectly with the exception of always extending the x axis for some reason (image below). I'd like the scale to end when the graph ends (keep in mind the graph is dynamic).
asd.PNG

Thank in advance for your help!

**Andy Pope** · 11-27-2018, 04:29 AM

As it is a scatter chart, rather than a categorical Line chart, the scale max will adjust to encompass the maximum data value.
If you want the horizontal axis to have a maximum of 100 you will need to add code to fix the maximumscale value