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

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

On Nov 10, 9:35 pm, "Bernard Liengme"
wrote:
Dynamic charts are discussed in these sites:http://peltiertech.com/Excel/Charts/...ps/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 MVPwww.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- Hide quoted text -

- Show quoted text -

Thankyou very much, Really helpfull as an MBA Grad/ working in
industrial engineering this is really useful. I have completed what I
needed to do.

Thanks for feedback
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email