View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
casey casey is offline
external usenet poster
 
Posts: 80
Default dynamic chart partial row

I am trying to create a dynamic chart (latest 25 months) using data added
monthly to columns. I have, however, uncharted data to the right of said
data (blank column separating). I've tried many OFFSET formulas with no
success. Sample data:

Col A Col B Col C Col D Etc
Entity Jan04 Feb04 Mar04 (Presently To Dec08)
A 25 17 9
B 58 22 13
C 109 39 24

TIA,
casey