Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

UPDATING CHARTS

Status
Not open for further replies.
Eurobum

Eurobum

Aerospace
Joined
Aug 20, 2001
Messages
27
Location
US

I used this formula defined in the "name" to auto-update my charts. It works fine when the range filled with all data.
As soon as I have a blank cell in my data column, instead of filling the whole column (till the end of the data) as it supposes to do, it just fills part of it. Can you help me to correct this formula :

=OFFSET('SHEET 1"!C15,1,0,COUNT('SHEET 1'!C16:C2000),1)

Thank you.
 
Status
Not open for further replies.

Similar threads

phamENG
  • Locked
  • Question Question
Auto-Updating Template
Replies
11
Views
546
Tuckabag
Tuckabag
JoelTXCive
  • Locked
  • Question Question
Updating Older Excel Macro That No Longer Runs
Replies
17
Views
745
cowski
cowski
hygear
  • Locked
  • Question Question
Material selection charts in Excel?
Replies
4
Views
741
robyengIT
robyengIT
macmet
  • Locked
  • Question Question
Turned Charts Off
Replies
4
Views
227
macmet
macmet
Mccoy
  • Locked
  • Question Question
Charts with >254 data series
2
Replies
20
Views
862
IDS
IDS

Part and Inventory Search

Sponsor

Back
Top