Automatically Update Excel Graphs
Hi,
My question has two parts to it --------------------------------------------------------- Part 1 --------------------------------------------------------- I have two worksheets: A and B. - Worksheet B contains all my data. - Worksheet A contains only data for the current week. e.g Week 20 and has a column showing a % change from week 19 to Week 20. - Worksheet A also has graphs for each data set in worksheet B to show a trend in sales. My Question: How can I set the graphs in Worksheet A to automatically update for only 8 weeks at a time (e.g I have 20 weeks worth of data but want the graphs to only display a trend for weeks 12-20). --------------------------------------------------------- Part 2 --------------------------------------------------------- How can I create a drop-down list in Worksheet A, which, when selected, produces a list of numbers 1 - 20 (for each week). When any of the weeks is selected, I would like Worksheet A to display data for the selected week and also the percentage change for the selected week to the previous week (and then of course, update the graphs as well). Any help would be very much appreciated. Nadia |
Automatically Update Excel Graphs
On May 22, 11:53*am, wrote:
Hi, My question has two parts to it --------------------------------------------------------- Part 1 --------------------------------------------------------- I have two worksheets: A and B. - Worksheet B contains all my data. - Worksheet A contains only data for the current week. e.g Week 20 and has a column showing a % change from week 19 to Week 20. - Worksheet A also has graphs for each data set in worksheet B to show a trend in sales. My Question: How can I set the graphs in Worksheet A to automatically update for only 8 weeks at a time (e.g I have 20 weeks worth of data but want the graphs to only display a trend for weeks 12-20). --------------------------------------------------------- Part 2 --------------------------------------------------------- How can I create a drop-down list in Worksheet A, which, when selected, produces a list of numbers 1 - 20 (for each week). When any of the weeks is selected, I would like Worksheet A to display data for the selected week and also the percentage change for the selected week to the previous week (and then of course, update the graphs as well). Any help would be very much appreciated. Nadia hi nadia, can u send me excel file.so i can work on that ? |
Automatically Update Excel Graphs
Hi Akhtar,
Thanks, I have emailed you a file :) Nadia |
Automatically Update Excel Graphs
1. Dynamic Charts:
http://peltiertech.com/Excel/Charts/DynamicLast12.html 2. Controls for Charts: http://peltiertech.com/Excel/Charts/DynamicLast12.html http://peltiertech.com/Excel/Charts/DynamicLast12.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... Hi, My question has two parts to it --------------------------------------------------------- Part 1 --------------------------------------------------------- I have two worksheets: A and B. - Worksheet B contains all my data. - Worksheet A contains only data for the current week. e.g Week 20 and has a column showing a % change from week 19 to Week 20. - Worksheet A also has graphs for each data set in worksheet B to show a trend in sales. My Question: How can I set the graphs in Worksheet A to automatically update for only 8 weeks at a time (e.g I have 20 weeks worth of data but want the graphs to only display a trend for weeks 12-20). --------------------------------------------------------- Part 2 --------------------------------------------------------- How can I create a drop-down list in Worksheet A, which, when selected, produces a list of numbers 1 - 20 (for each week). When any of the weeks is selected, I would like Worksheet A to display data for the selected week and also the percentage change for the selected week to the previous week (and then of course, update the graphs as well). Any help would be very much appreciated. Nadia |
All times are GMT +1. The time now is 07:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com