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.