Simple charting query

[HR_Steve]

H
I am looking to create a chart that will show some weekly stats. The first week involves current vacancies as at 21 Jan, 2004

The fields are
Advertised Internal | Advertised External | Tota
Australia Sales 21 38 5
Aus Non-Sales 15 33 4
NZ Sales 6 8 1
NZ non-sales 0 4
Total 42 83 12

I am looking for a chart which will eventually have a rolling display of 52 weeks at a time. I am open to any suggestions about the best way to display this. Your help is much appreciated

Thank

Steve

 

[Debra Dalgleish]

Jon Peltier has instructions for creating a dynamic chart. You could
adapt the example for your data:

http://www.peltiertech.com/Excel/Charts/DynamicLast12.html

 

[Tushar Mehta]

You can check a variety of different dynamic charts at the Excel |
Tutorials | Dynamic Charts page of my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions