Offset Question

[Al Mackay]

So close....

Was trying to do this myself, thought the logic was there but
obviously I'm missing something still.

Basically want to have a chart automatically update to show additional
rows (therefore months) depending on the current month.

Table goes from B6:H18 (Row 6 Contains titles:
Month,Raised,Closed,Progress,Planned, Projected)

Rows 7:18 contain the appropriate data for each month, column B
containing all months.

Was hoping to have the chart basically recognise when a new months of
data should be shown (e.g. currently May so only show data up to row
11).

My Version:
=OFFSET(Main Data!$B$6,0,0,MONTH(NOW())+1,6)

Could anyone help with this @ all. For info Column C is a hidden
column containing data I don't want to chart. If this needs to be
moved to the end of the table to make it easier to do I can do this.

Many Thanks, Al ( (e-mail address removed) )

 

[Don Guillett]

If your dates are only one date per month then this should work. Hidden
columns are not charted or you can adjust your series without hiding, if
desired. This guy knows ALL about charting.
Jon Peltier's Excel Page

 

[Don Guillett]

http://www.geocities.com/jonpeltier/Excel/index.html