I'm adding a chart to an existing spreadsheet with the following:

ActiveChart.Location Whe=xlLocationAsObject, Name:="IPS"

However, it's leaving too much which space between the bottom of the
existing data, and the start of the chart.

Can I specify a specific cell location for the chart to be place? Something
like:

activechart.location whe=Range("A42"), Name:="IPS"

Thanks
Fred