For a tutorial on how to create a dynamic chart see
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html
particularly the later examples. Of course, you will have to adapt the
ideas to plot data in a row rather than in a column.

I thought I had posted code that adjusted a chart based on the
currently selected cell. But, I cannot find it through a search of the
google archives of the XL newsgroups. Maybe, you will have better luck
searching for code I posted. ;-)


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Can I create a chart that delineates any row I choose without creating a new
chart each time?

The data I want to chart resides in columns B through BD and rows 22 through
1000. I'd like to use one chart that changes rows easily without having to
recreate the chart for each row of data.