Using formula to calculate data source range
Is there any way to referencing to data source range with formula?
For example I would like to insert this formula to the data surce page (if it would be possible) : =Address(32;12;1;True;"DEF_Montly")&":"&address(32 ;DEF_Monthly!$A$1;1;True) its value is: "DEF_Monthly!$L$32:$Q$32" So this way I could expand or reduce the range dinamically. Can anyone help me? Edit. |
Using formula to calculate data source range
You can't link the whole data range of a chart to a dynamic range like this;
Excel accepts the name but converts it into a non-dynamic cell address. You can link the X and Y values of each series to a dynamic range, and these stick. http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ebarathne" wrote in message ... Is there any way to referencing to data source range with formula? For example I would like to insert this formula to the data surce page (if it would be possible) : =Address(32;12;1;True;"DEF_Montly")&":"&address(32 ;DEF_Monthly!$A$1;1;True) its value is: "DEF_Monthly!$L$32:$Q$32" So this way I could expand or reduce the range dinamically. Can anyone help me? Edit. |
All times are GMT +1. The time now is 10:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com