Simple charting query

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

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

http://www.peltiertech.com/Excel/Ch...amicLast12.html

HR_Steve wrote:
> Hi
> 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 | Total
> Australia Sales 21 38 59
> Aus Non-Sales 15 33 48
> NZ Sales 6 8 14
> NZ non-sales 0 4 4
> Total 42 83 125
>
> 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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

In article <3DBBF438-0960-4D7F-BB84-6E54C7D2EE63@microsoft.com>,
steven.horne@cadburyschweppes.com.au says...
> Hi
> 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 | Total
> Australia Sales 21 38 59
> Aus Non-Sales 15 33 48
> NZ Sales 6 8 14
> NZ non-sales 0 4 4
> Total 42 83 125
>
> 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.
>
> Thanks
>
> Steve
>