Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can xy graph origin be control 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.programming
|
|||
|
|||
Can xy graph origin be control from a cell?
Use the change event to detect the change in the cell and then do the VBA
equivalent to what you describe doing manually in your post. Information on events http://www.cpearson.com/excel/events.htm and numerous posts in this newsgroup. http://tinyurl.com/ypof8t for some examples to get code on changing the axis, turn on the macro recorder while you do it manually. Turn off the macro recorder and study the code recorded. -- Regards, Tom Ogilvy "Jo" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can xy graph origin be control from a cell?
On Aug 2, 10:50 am, Tom Ogilvy
wrote: Use the change event to detect the change in the cell and then do the VBA equivalent to what you describe doing manually in your post. Information on eventshttp://www.cpearson.com/excel/events.htm and numerous posts in this newsgroup.http://tinyurl.com/ypof8t for some examples to get code on changing the axis, turn on the macro recorder while you do it manually. Turn off the macro recorder and study the code recorded. -- Regards, Tom Ogilvy "Jo" wrote: 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- Hide quoted text - - Show quoted text - Tom, Yes, but I guess I am missing something here. Say the origin was (0,0) and want to change it to (2,5). When I click on either x or y axis, I need to type that value which is 2 or 5. So, if I am using macro, how would the macro record those new origin values? Thanks, Mike |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can xy graph origin be control from a cell?
As answered in the other group:
http://peltiertech.com/Excel/Charts/...nkToSheet.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tom Ogilvy" wrote in message ... you said: is there a way to do so from a cell? so you would write the event code to trap the entry you make in a specific cell or specific cells (1 for x, 1 for y) and use the values placed there to update the graph using the code you recorded. -- Regards, Tom Ogilvy "Jo" wrote: On Aug 2, 10:50 am, Tom Ogilvy wrote: Use the change event to detect the change in the cell and then do the VBA equivalent to what you describe doing manually in your post. Information on eventshttp://www.cpearson.com/excel/events.htm and numerous posts in this newsgroup.http://tinyurl.com/ypof8t for some examples to get code on changing the axis, turn on the macro recorder while you do it manually. Turn off the macro recorder and study the code recorded. -- Regards, Tom Ogilvy "Jo" wrote: 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- Hide quoted text - - Show quoted text - Tom, Yes, but I guess I am missing something here. Say the origin was (0,0) and want to change it to (2,5). When I click on either x or y axis, I need to type that value which is 2 or 5. So, if I am using macro, how would the macro record those new origin values? Thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graph size control | Excel Discussion (Misc queries) | |||
Can xy graph origin be controlled from a cell? | Excel Discussion (Misc queries) | |||
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 |