I have an analysis workbook that each time my script is run, the workbook is opened and a new line of data is added to it. The worksheet is linked to a graph that is plotted against date. When the new data is added, the graph updates automatically no problem and plots correctly but the axis scale does not update.
What Command do I use to change the range of the scale when it is in date format? I have tried:
layer.x.to=01.01.2013 and layer.x.to=01012013
but they are just read as numbers and therefore change the format of my axis, Origin then has a mental breakdown and can't process the date format tick labels so Im just left with a big gray square.
Changing Axis Scale (Date Format)
Posted - 10/23/2013 : 09:34:04 AM
