| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| update week to week in excel. | Excel Worksheet Functions | |||
| how to chart data spread over 24 hours a day and 7 days a week? | Charts and Charting in Excel | |||
| Chart Property Confusion | Charts and Charting in Excel | |||
| Line Chart with dates in 5 day working week only | Charts and Charting in Excel | |||
| user defined function | Excel Worksheet Functions | |||
Linear Mode
