Thread: How do I automatiicaly redefinie Source data range for a chart?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
triamme triamme is offline
external usenet poster
  
Posts: 1
Default How do I automatiicaly redefinie Source data range for a chart?
I have A Chart Defined by Category (X) values in Collumn B and Y values in
Collumn C. Right now Both are defined by rows 4 to 114.
I would like to be able to have the chart automatically redefine itself so
if I put a value in C115 the chart would automaticaly set Y value range to be
C4:C115 eithout having to manually define chart. Is this possible? If so
how? I've tried OFFSET bu so far no luck.
Reply With QuoteReply With Quote