How do I control the position of a chart on the Excel sheet using Datanitro? I thought that by setting the active cell it would be positioned there but it always comes out as top left where it obscures cells with calculated results that I want to remain visible.
You can pass x and y to Image to position a chart: https://datanitro.com/docs/images.html#x
With nitroplot, you can pass x and y to the graph library:
nitroplot.graph(x = 123, y = 456)