Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to change graph ranges?
use named ranges instead of actual ranges, then just change what is in the
named range range "Jase" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referring to Ranges in Change-Event Macro? | Excel Discussion (Misc queries) | |||
macro to change date ranges | Excel Discussion (Misc queries) | |||
revenue ranges in scatterplot graph | Excel Discussion (Misc queries) | |||
graph multiple data ranges | Charts and Charting in Excel | |||
Problem with graph ranges | Charts and Charting in Excel |