rolling twelve week trend chart
I'm tracking stock prices over the course of the year. I want to create a
chart that shows the past 12 weeks of data. When I enter the new closing price I want the 12 week chart to update with the past 12 weeks. I now have to go into each chart and change the source of each chart to reflect this. I would like to have this function done automatically. The data is 34 rows by 64 columns. -- Thanks, Kreig |
rolling twelve week trend chart
This is the past 12 months, which you should easily be able to adapt:
http://peltiertech.com/Excel/Charts/DynamicLast12.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Kreig" wrote in message ... I'm tracking stock prices over the course of the year. I want to create a chart that shows the past 12 weeks of data. When I enter the new closing price I want the 12 week chart to update with the past 12 weeks. I now have to go into each chart and change the source of each chart to reflect this. I would like to have this function done automatically. The data is 34 rows by 64 columns. -- Thanks, Kreig |
All times are GMT +1. The time now is 02:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com