Thread
:
Need a Dynamic Chart
View Single Post
#
3
Posted to microsoft.public.excel.programming
Andy Pope
external usenet poster
Posts: 2,489
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
Reply With Quote
Andy Pope
View Public Profile
Find all posts by Andy Pope