View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JB JB is offline
external usenet poster
 
Posts: 115
Default Dynamic chart -easy question that has me stuck

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,GrapheD yn55.xls!CaMois5,1)

JB
http://boisgontierjacques.free.fr/

On 9 sep, 13:25, (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?