I'm using Microsoft Office Excel 2007 and hang on to a graph that have strong views (number) on the y-axis vs date (ie 10/20/2007) on the x-axis. My request for information is how I can achieve the graph to automatically read the current date and tweaking (increase) the maximum good point on the x-axis to become doesn`t matter what the current date is. I'm not *that* experienced next to Macros but if that's what I call for to do after permit me know. Thanks within mortgage.
Answers: The best course to do that is to say to use the Macro Recorder to serve you out.
Turn the macro recorder on and own it CD as you translate the date and values to receive the chart to look the instrument you want it to look. Once you go and get it to look the approach you want it too, next step final to the macro you a moment ago record and click the Edit button. This will verbs up the Macro code. You'll want to find or integer out what the heading is for the intent that you changed the date good point. The recorder should enter contained by that days date. For instance, today is 10/22/2007. If you enter the date today it would enter contained by the actual date approaching that (10/22/2007), deeply a frozen number that doesn't renovate. What you obligation is a formula that give you today's date. You obligation to revision where on earth it sets the advantage to 10/22/2007 to:
= Now()
That will impart you the current day's date.
You later may want to pilfer that macro code and copy it. In the Project Explorer fanlight to the moved out side of Visual Basic Explorer you will see a roll of the worksheets. Double-click on the sheet that have your chart. Then above the hot blank code sheet that appears you will see two drop-down combo boxes. Change the one that say General by Selecting Worksheet from the index. Then translation the right one to Activate. Paste your code from the macro you record and modified (everything inside the two lines that own the word Sub, don't include the Sub lines). And fasten it to where on earth the cursor is.
This should update the date whenever you generate the worksheet that have your chart. So the chart should be updated whenever anyone view it.
If you requirement more support, email me. It's not the easiest to explain online.