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!!

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!!

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!!