button for pie

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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.
 
I dont know how to do this could you explain? or give me a link that explains
it...

Thanks!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with recording a macro, attaching a button 9
Excel Can a pie of pie chart use animation/transitions? 1
Show Total In a Text Box in a Pie Chart 2
auto update pie chart 1
Smooth out pie 3
pie explosion 3
Excel Charts 1
Chart Help 1

Back
Top