Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc
|
|||
|
|||
How to control y scaling from worksheet
Dear experts!
I know it is possible to control source data ranges from worksheet. Is there a way to control y scaling (minimum, maximum) from worksheet too? Thanks for answers, Marko |
#2
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc
|
|||
|
|||
How to control y scaling from worksheet
Marko -
You need to use VBA to do this for you. Here is the necessary code: http://peltiertech.com/Excel/Charts/...nkToSheet.html If you want a ready-to-use solution, try Tushar Mehta's AutoChart Manager add-in, available as a free download at http://www.tushar-mehta.com. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Marko Pinteric" wrote in message ... Dear experts! I know it is possible to control source data ranges from worksheet. Is there a way to control y scaling (minimum, maximum) from worksheet too? Thanks for answers, Marko |
#3
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc
|
|||
|
|||
How to control y scaling from worksheet
So VBA is the only way. Thanks for the answer. Marko Jon Peltier wrote: Marko - You need to use VBA to do this for you. Here is the necessary code: http://peltiertech.com/Excel/Charts/...nkToSheet.html If you want a ready-to-use solution, try Tushar Mehta's AutoChart Manager add-in, available as a free download at http://www.tushar-mehta.com. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Marko Pinteric" wrote in message ... Dear experts! I know it is possible to control source data ranges from worksheet. Is there a way to control y scaling (minimum, maximum) from worksheet too? Thanks for answers, Marko |
#4
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc
|
|||
|
|||
How to control y scaling from worksheet
Well, no. I use a non-VBA worksheet function technique in some proprietary
workbooks. It's complex enough that I can't do it justice in a newsgroup post, and I have not had time to generate a web page describing it. Basically it requires calculating appropriate axis scale parameters (based on the data or on user overrides), scaling the data from 0 to 1 (between the calculated min and max), plotting the transformed data on a scale of 0 to 1, hiding the regular chart axis, and creating a custom axis based on the calculated parameters. The custom axis part is shown he http://peltiertech.com/Excel/Charts/...tml#axisscales Several of these links show the use of transformed data. For now you'll have to come up with your own algorithms for axis scale parameters. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Marko Pinteric" wrote in message ... So VBA is the only way. Thanks for the answer. Marko Jon Peltier wrote: Marko - You need to use VBA to do this for you. Here is the necessary code: http://peltiertech.com/Excel/Charts/...nkToSheet.html If you want a ready-to-use solution, try Tushar Mehta's AutoChart Manager add-in, available as a free download at http://www.tushar-mehta.com. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Marko Pinteric" wrote in message ... Dear experts! I know it is possible to control source data ranges from worksheet. Is there a way to control y scaling (minimum, maximum) from worksheet too? Thanks for answers, Marko |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One worksheet to calulate different items simultaneously | Excel Worksheet Functions | |||
Extracting data from one Worsheet to Another Worksheet with common link value | Excel Discussion (Misc queries) | |||
Worksheet Revision Date only once that day | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions |