How to anchor charts to a cell location ?
I have a macro which creates several charts and puts then on the excel
sheet in the midst of the data.
Note: FN is the filename of the result sheet.
ActiveChart.ChartType = xlLine
ActiveChart.Location Where:=xlLocationAsObject, Name:=FN
However, the initial location of the charts in the middle of the sheet
is influenced by the current view of the spreadsheet. Moves ( ie:
ActiveSheet.Shapes(ChartName).IncrementLeft -165 ) are relative to the
location of the chart, not to the activecell.
Is there any way to insert a chart over a range of cells or at an
absolute location or to move the chart relative to the ActiveCell?