software

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.

Hi Nick,

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

Ed Ferrero
Microsoft Excel MVP
www.edferrero.com

gt; Can I create a chart that delineates any row I choose without creating a
gt; new
gt; chart each time?
gt;
gt; The data I want to chart resides in columns B through BD and rows 22
gt; through
gt; 1000. I'd like to use one chart that changes rows easily without having to
gt; recreate the chart for each row of data.
For a tutorial on how to create a dynamic chart see
Dynamic Charts
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 gt;,says...
gt; Can I create a chart that delineates any row I choose without creating a new
gt; chart each time?
gt;
gt; The data I want to chart resides in columns B through BD and rows 22 through
gt; 1000. I'd like to use one chart that changes rows easily without having to
gt; recreate the chart for each row of data.
gt;