Hi Nick,

Go to http://www.edferrero.com/charting.aspx and download 'Chart Selector'

Ed Ferrero
Microsoft Excel MVP
http://www.edferrero.com

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.