I have a defined chart area called "PltChartRange" and in a macro I insert a row to expand the chart range each time expecting that the chart will grow based on the insert. Is there a setting that the chart needs to know it has to expand?
Even if I manually insert a row in the chart range it should expand the range right?
I attached a sample file to reivew. Why does the chart not expand? Also it looks like the chart is expanding vertically as the rows are added, but not horizontally to add new rows?
Something is wrong.
Quick code to add a row at row 2 to expand does not show in the chart?
' Macro4 Macro
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
ActiveCell.FormulaR1C1 = "=NOW()"
ActiveCell.FormulaR1C1 = "500"
ActiveCell.FormulaR1C1 = "250"
ActiveCell.FormulaR1C1 = "50%"