Dynamic charts are discussed in these sites:
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html
http://office.microsoft.com/en-us/ex...098011033.aspx
http://people.stfx.ca/bliengme/ExcelTips/Dynamic.htm
Also if you have Excel 2003 and you turn the data you chart into a List
(select all the data and use Data | List | Create) then the chart is
automatically dynamic. Works only when the x-values are in a column (as you
have) not in a row.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
wrote in message
ups.com...
Hi
I have to update a weekly spreadsheet
With week numbers in column B x series and three y series percentages
in G,H,I columns.
Could someone please help I need these to update automatically. If
someone can explain in detail I would appreciate
39 2097 2165 68 1770.7 97 96.86 118.43
40 2443.15 2201 -242.15 1548.93 97 111.00 157.73
41 2162.83 2259 96.17 1600.78 97 95.74 135.11
42 2163.08 2241 77.92 1545.1 97 96.52 140.00
43 2137.5 2271 133.5 1664.6 97 94.12 128.41
44 2160.67 2298 137.33 1455 97 94.02 148.50
Ta
Brian