How do I get a graph to automatically update when I enter new data (I am using Excel 2003)? I have seen how some people suggest naming ranges using the OFFSET function. However, this only appears to work when the data is listed vertically.
My data is listed horizontally - i.e. row B1 contains "November 2000," and each column contains another month up to CZ1 which contains "May 2009." This data is updating each month.
Morover, I have a line graph that tracks the sales of multiple items - ie rows 2 through 5 are apples, oranges, grapes, bananas. Each month, the sales of each of the four items are updated, and I would like my line graph to update automatically. Please help. Thank you.