Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Dynamic Chart
Hi All,
I'm having a sales data for 10 weeks in a seperate Worksheet. Every week I get a data which I append to the existing data. So the data grows on a Weekly basis. In another worksheet, I need design a graph, which depicts the sales figure for the last 5 weeks. say for ex. Imy graph currently displays data for the weeks 5-10. When I append the 11th week data, I need the graph to dynamically show the data for 6-11 weeks. Is it possible to do it in Excel.? Any help will be highly appreciated. Thanks Moorthy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Dynamic Chart
You should give the format of how the data looks in your sheet to work
out a solution. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Dynamic Chart
Hi
Have a read of Jon Peltier's article, http://pubs.logicalexpressions.com/P...cle.asp?ID=246 Cheers Andy wrote: Hi All, I'm having a sales data for 10 weeks in a seperate Worksheet. Every week I get a data which I append to the existing data. So the data grows on a Weekly basis. In another worksheet, I need design a graph, which depicts the sales figure for the last 5 weeks. say for ex. Imy graph currently displays data for the weeks 5-10. When I append the 11th week data, I need the graph to dynamically show the data for 6-11 weeks. Is it possible to do it in Excel.? Any help will be highly appreciated. Thanks Moorthy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Dynamic Chart
Hi
In NG microsoft.public.excel.worksheet.functions i explained how to do this in general (look in thread "excel charts, simpla question") For your case, you have to define named ranges in a way, that only data from last N weeks are included - how to do this, depends on your table design. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) wrote in message oups.com... Hi All, I'm having a sales data for 10 weeks in a seperate Worksheet. Every week I get a data which I append to the existing data. So the data grows on a Weekly basis. In another worksheet, I need design a graph, which depicts the sales figure for the last 5 weeks. say for ex. Imy graph currently displays data for the weeks 5-10. When I append the 11th week data, I need the graph to dynamically show the data for 6-11 weeks. Is it possible to do it in Excel.? Any help will be highly appreciated. Thanks Moorthy |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Dynamic Chart
Sorri!
thread "excel charts, simple question" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic chart- curve dropping to zero ( chart type- Line) | Charts and Charting in Excel | |||
Dynamic Chart Title With 3D Stacked Column Chart | Charts and Charting in Excel | |||
Dynamic chart pasted to a new workbook in report can't be dynamic | Charts and Charting in Excel | |||
Chart empty with new data in the dynamic range chart. | Excel Discussion (Misc queries) | |||
Dynamic Chart Range and Chart Update | Excel Programming |