There are excellent instructions for creating a dynamic chart at:
http://www.peltiertech.com/Excel/Cha...umnChart1.html

That source data is presented vertically.

How do I modify the formulas to get a dynamic chart when my source
data is horizontal across columns A-Z for example?

Months with CA only

http://cjoint.com/?jjoMrDRfHw

-Create Names with Insert/Name

Mois5
=Offset($B$1,,,1,CountA($2:$2)-1)

CaMois5
=Offset($B$2,,,1,CountA($2:$2)-1)

Click on Serie:
=SERIE(GraphDyn!$A$2;GrapheDyn55.xls!Mois5,GrapheDyn55.xls!CaMois5,1)

JB
http://boisgontierjacques.free.fr/

On 9 sep, 13:25, glen...@nospam.com (glenlee) wrote:
> There are excellent instructions for creating a dynamic chart at:http://www.peltiertech.com/Excel/Cha...umnChart1.html
>
> That source data is presented vertically.
>
> How do I modify the formulas to get a dynamic chart when my source
> data is horizontal across columns A-Z for example?

With this data:
<blank> week1 week2 week3 week4 week5 week6
units 1 2 3 4


Define ChartValues as: =OFFSET(Sheet1!$A$2,0,1,1,COUNTA(Sheet1!$2:$2)-1)
Define ChartLabels as: =OFFSET(chartvalues,-1,0)

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"glenlee" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> There are excellent instructions for creating a dynamic chart at:
> http://www.peltiertech.com/Excel/Cha...umnChart1.html
>
> That source data is presented vertically.
>
> How do I modify the formulas to get a dynamic chart when my source
> data is horizontal across columns A-Z for example?

Additional note: if you make the data a List in XL2003 or a Table in XL2007,
then make the chart, the chart is automatically updated when data is added
to the List/Table
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"glenlee" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> There are excellent instructions for creating a dynamic chart at:
> http://www.peltiertech.com/Excel/Cha...umnChart1.html
>
> That source data is presented vertically.
>
> How do I modify the formulas to get a dynamic chart when my source
> data is horizontal across columns A-Z for example?

That's what I'm looking for....thanks much.

On Sun, 9 Sep 2007 10:06:59 -0300, "Bernard Liengme"
<(E-Mail Removed)> wrote:

>With this data:
> <blank> week1 week2 week3 week4 week5 week6
> units 1 2 3 4
>
>
>Define ChartValues as: =OFFSET(Sheet1!$A$2,0,1,1,COUNTA(Sheet1!$2:$2)-1)
>Define ChartLabels as: =OFFSET(chartvalues,-1,0)
>
>best wishes
>--
>Bernard V Liengme
>Microsoft Excel MVP
>www.stfx.ca/people/bliengme
>remove caps from email
>
>"glenlee" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> There are excellent instructions for creating a dynamic chart at:
>> http://www.peltiertech.com/Excel/Cha...umnChart1.html
>>
>> That source data is presented vertically.
>>
>> How do I modify the formulas to get a dynamic chart when my source
>> data is horizontal across columns A-Z for example?
>
>

Yes, but you'll have to put the data in columns.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bernard Liengme" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Additional note: if you make the data a List in XL2003 or a Table in
> XL2007, then make the chart, the chart is automatically updated when data
> is added to the List/Table
> best wishes
> --
> Bernard V Liengme
> Microsoft Excel MVP
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "glenlee" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> There are excellent instructions for creating a dynamic chart at:
>> http://www.peltiertech.com/Excel/Cha...umnChart1.html
>>
>> That source data is presented vertically.
>>
>> How do I modify the formulas to get a dynamic chart when my source
>> data is horizontal across columns A-Z for example?
>
>