Hi-
I have a line chart with 5 points of data (Product A, Product B, Product C, Product D, and Product E) for 365 days. The chart is obviously very very crowded. I am trying to find a way to add scrolling to the chart so that only 7 or 14 days worth of data shows at one time. I have found a few examples online (all seem to include the OFFSET function), but I just can't seem to get anything to work. Does anyone know how to do this? I am working with Excel 2007. Thanks!!!!!
Meg
Chart.jpg
Bookmarks