I made a chart using a dynamic range, four qtr
In the chart the four qtr data series (in Red) is based on a named range THM501. THM501 named range is defined as =OFFSET(A11,0,1,,COUNT(E11:L11)+3).
This is my problem:
1) When you have open the file, data series four qtr displays but if you add data to cell J9, the chart line four qtr disappears. Why?
How can this be corrected?
File is attached
Help is appreciated
Click on star (*) below if this helps
You need to lock your ranges:
=OFFSET('THM Site #1 April 2012 -'!$A$11,0,1,,COUNT('THM Site #1 April 2012 -'!$E$11:$L$11)+3)
Otherwise they will convert to 65536 which is the last row.
Last edited by RobertMika; 02-17-2014 at 03:36 PM.
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
That didn't help but I was get it to work myself
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks