| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
button for pie
hello,
I have 3 cells that have a number or % in them that I want on this graph. Cell AX25, AO28 and AT26. Is there anyway I can have a button on my sheet with these numbers and by pressing it will take me to a sheet in my workbook and show the data in those 3 cell in a pie chart? Also if the data changes in those 3 cells the data in the chart will change as well. Please help or send me in the right direction... Thanks!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
button for pie
If you know how to do it manually in Excel then just use the Macro recorder
to record the necessary steps and then attached the Macro to a button. The button can be gotten from the menu, View, Tool Bars, and Forms. You can then attach the Macro to the button. Good luck. "oxicottin" wrote: hello, I have 3 cells that have a number or % in them that I want on this graph. Cell AX25, AO28 and AT26. Is there anyway I can have a button on my sheet with these numbers and by pressing it will take me to a sheet in my workbook and show the data in those 3 cell in a pie chart? Also if the data changes in those 3 cells the data in the chart will change as well. Please help or send me in the right direction... Thanks!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
button for pie
I dont know how to do this could you explain? or give me a link that explains
it... Thanks!! "Richard" wrote: If you know how to do it manually in Excel then just use the Macro recorder to record the necessary steps and then attached the Macro to a button. The button can be gotten from the menu, View, Tool Bars, and Forms. You can then attach the Macro to the button. Good luck. "oxicottin" wrote: hello, I have 3 cells that have a number or % in them that I want on this graph. Cell AX25, AO28 and AT26. Is there anyway I can have a button on my sheet with these numbers and by pressing it will take me to a sheet in my workbook and show the data in those 3 cell in a pie chart? Also if the data changes in those 3 cells the data in the chart will change as well. Please help or send me in the right direction... Thanks!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Matching Button for MS Excel 2007 or later | Excel Worksheet Functions | |||
| A button for Center Across Selection | Excel Discussion (Misc queries) | |||
| Assigning a macro to a command button | Excel Discussion (Misc queries) | |||
| Runing two macros triggered by a button | Excel Discussion (Misc queries) | |||
| Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
Linear Mode
