Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 10-06-2020, 10:37 PM
ArviLaanemets ArviLaanemets is offline Chart with Dynamic Array Windows 8 Chart with Dynamic Array Office 2016
Expert
 
Join Date: May 2017
Posts: 960
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

A foolproof way to define dynamic named ranges is to use OFFSET().

E.g.
Code:
=OFFSET(AnchorPoint, RowsDown, ColumnsRight, NumberOfRows, NumberOfColumns)
where
AnchorPoint is address of some single cell which you are sure it will never be deleted, and is above or in same row as the range you want to define, and left or in same column as the range you want to define;
RowsDown is the number of rows from AnchorPoint to topmost row of range you want to define;
ColumnsRight is the number of columns from AnchorPoint to leftmost column of range you want to define;
NumberOfRows is the number of rows you want in defined range;
NumberOfColumns is the number of columns you want in defined range.

E.g. you want to define a range P5:P1, anchored to cell P1:
Code:
=OFFSET($P$1,4,,6,1)
To make the range dynamic, you have to replace at least one of parameters to be calculated by formula.

To get any detailed help you have to attach some example table here.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a dynamic array for some formulas Bumba Excel 2 01-27-2019 05:10 AM
Fixing legend of a dynamic chart Toonook Excel 0 08-25-2016 04:46 PM
Chart with Dynamic Array Dynamic chart ranges GlowingApple Excel 1 02-17-2016 07:18 PM
Generating a chart with dynamic series Officer_Bierschnitt Excel 3 10-15-2015 12:30 AM
Dynamic Chart with Non Continuous data swati_04 Excel 0 03-02-2015 12:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft