Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007: Graph macro using reletive reference?
Hi,
I recorded the following macro: Sub Past_month_click() ' ActiveSheet.ChartObjects("Graph 15").Activate ActiveSheet.ChartObjects("Graph 15").Activate ActiveChart.SetSourceData Source:=Range("B50:H54") End Sub What do I want to accomplish? I have a range of data per month. When I do my thing in the sheet I want to add the last month to my graph. In Excel I have to right click the graph, change the data range, press the right key, followed by pressing the Enter key. This I would like to do by the macro. So, the Range("B50:H54") must become a relative reference. What do I need to change in the above code to accomplish that? Abel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Cell Reference - Excel 2007 | Excel Discussion (Misc queries) | |||
Reletive Referencing - Marco issues | Excel Programming | |||
Transpose Reletive Cell References? | Excel Worksheet Functions | |||
paste reletive reference in pivot table | Excel Discussion (Misc queries) | |||
Reletive Referencing of Another Cell's Formulas | Excel Programming |