It's not clear what you're trying to do, but you may get some ideas from
Jon Peltier's instructions for interactive charting:

http://www.peltiertech.com/Excel/Cha...ByControl.html

pete3589 wrote:
I wanted to use a pushbutton to pop up a graph. What would be the
proper text I would enter in the cell to do this if I wanted to graph
column A with column Y as an xy scatter.

Im hoping to avoid using the VB editer on this if possible.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html