Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Button Pops up Graph
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. -- pete3589 ------------------------------------------------------------------------ pete3589's Profile: http://www.excelforum.com/member.php...o&userid=28402 View this thread: http://www.excelforum.com/showthread...hreadid=482029 |
#2
|
|||
|
|||
Button Pops up Graph
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 |
#3
|
|||
|
|||
Button Pops up Graph
Thanks for the reply Debra. Some of information on that document helped, and I plan to implement it. Lets say I were to use a list form like the ones on that page to pick the value I want to graph. How could I have a button that when i press it, would bring up a graph with time a time value on the x axis, and then the selected data array on the Y axis? Thanks -- pete3589 ------------------------------------------------------------------------ pete3589's Profile: http://www.excelforum.com/member.php...o&userid=28402 View this thread: http://www.excelforum.com/showthread...hreadid=482029 |
#4
|
|||
|
|||
Button Pops up Graph
If you follow the examples on the page, you don't need a button. The
chart changes when you select an item from the list. pete3589 wrote: Thanks for the reply Debra. Some of information on that document helped, and I plan to implement it. Lets say I were to use a list form like the ones on that page to pick the value I want to graph. How could I have a button that when i press it, would bring up a graph with time a time value on the x axis, and then the selected data array on the Y axis? Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graph Help- 12 month graph, but only want months that have passed | Charts and Charting in Excel | |||
Command Button anomalies | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Command Button VBA code | Excel Discussion (Misc queries) | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) |