new cell entry reflected in chart

Posted by Robin T on April 23, 2001 6:45 PM

I am creating a worksheet that posts a wiegh-in date and weight and has a scatter chart to visually display the weight loss progress.
The range is displayed in the chart and I have a button to insert a new row to input new wiegh-ins. How can I get this new column to display on the chart.
Thanks,
Robin T

Posted by robin t on April 23, 2001 7:01 PM

more info:

I have a cell named and insert to the left of it but the named cell displayes as well.
I don't want the named cell to display, but was trying to get everything to the left to show in the chart.

Sub Weigh_In()
'
' Weigh_In Macro
' Macro recorded 4/22/2001 by robin
''
Application.Goto Reference:="Current_Weight_Loss"
Selection.EntireColumn.Insert

End Sub

Posted by Dave Hawley on April 23, 2001 10:24 PM

Weigh_In Macro Macro recorded 4/22/2001 by robin '

Hi Robin

Not too sure I have understood you here, but rather than Insert a new Row, have it there already (but hiiden) and simply Unhide it. Excel will not plot hidden rows or columns. Another alternative would be to use a "Dynamic Range". I have many examples of these on my Website under "Dynamic Ranges". I also have some tips for Charts that may help, they are under "Chart Tips and Tricks".

Dave

OzGrid Business Applications

Posted by robin t on April 24, 2001 4:26 PM

: more info: : I don't want the named cell to display, but was trying to get everything to the left to show in the chart. : ' : ' Weigh_In Macro : ' Macro recorded 4/22/2001 by robin : '' : Application.Goto Reference:="Current_Weight_Loss" : Selection.EntireColumn.Insert : : End Sub

Hi Robin Dave

Yeah!!!! Hiding the cell works perfectly.

I have your website bookmarked, as I am a beginner with Excel VBA and programming!

Thanks a million.

--Robin