View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Dynamic chart -easy question that has me stuck

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" wrote in message
...
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?