macro to change graph ranges?

J

Jase

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
 
D

dlw

use named ranges instead of actual ranges, then just change what is in the
named range range
 

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

Getting the graph style I want 4
syntax to concatenate two named ranges? 2
Dynamic graph issue 2
filtering ranges 3
Task Information Dialog Box not making duration changes to task 0
Graph Autorange 2
Setting column width in a table with a macro is not working 0
update graphs automatically either from same book or a new spreads 1

Top