dynamic charting

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/n...arts/index.html
http://office.microsoft.com/en-us/e...1098011033.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

<brian.baker13@googlemail.com> wrote in message
news:1194708932.388378.155790@v3g2000hsg.googlegroups.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" <blien...@stfx.TRUENORTH.ca>
wrote:
> Dynamic charts are discussed in these sites:http://peltiertech.com/Excel/Charts...ips/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
>
> <brian.bake...@googlemail.com> wrote in message
>
> news:1194708932.388378.155790@v3g2000hsg.googlegroups.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