Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can xy graph origin be controlled from a cell?
Hi everyone,
Say you have xy graph with (0,0) as its origin. Of course you can make the origin has any non-zero value by clicking the x axis and chaging the value from 0 to, say, 5. Same thing to y axis by clicking on it. If I have to make the origin value change frequently, is there a way to do so from a cell? Thanks, Jo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can xy graph origin be controlled from a cell?
You need to rely on a little VBA for this:
http://peltiertech.com/Excel/Charts/...nkToSheet.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jo" wrote in message oups.com... Hi everyone, Say you have xy graph with (0,0) as its origin. Of course you can make the origin has any non-zero value by clicking the x axis and chaging the value from 0 to, say, 5. Same thing to y axis by clicking on it. If I have to make the origin value change frequently, is there a way to do so from a cell? Thanks, Jo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Destination cell to ref origin cell, but w/ many variables..H | Excel Worksheet Functions | |||
how do I create a line graph from a common origin? | Charts and Charting in Excel | |||
How to create a link including all formatting from origin cell? | Excel Worksheet Functions | |||
Autoshape in Chart controlled from a different worksheet | Charts and Charting in Excel | |||
Date controlled function execution | Excel Worksheet Functions |