View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jase jase is offline
external usenet poster
 
Posts: 117
Default macro to change graph ranges?

I have a few different graphs that all read the same amount of data ranges.
My data is constantly changing between about 10 to 12 cells worth of data and
everytime it changes back and forth i have to go in and change all the graph
ranges manually. Is there a way to have a toggle button that allows me to
change all my ranges from my excel sheet rather then going into each graph?

thanks,

Jase