Hi all
I'm hoping that you'll be able to help me, because I'm totally lost
I'm trying to create a macro based on the below table:
2004 2005 2006 2007 2008...
Company #1
Company #2
Company #3
Company #4
I have created a chart based on the data I have available (it is financial data, so I only have available until 2007). What I want is that when I input data for 2008, the chart is automatically updated to contain this year as well. Can you help me?