A
Al Mackay
Unfortunately my last post appeared to get linked to other postings.
Could anyone help me with the following @ all?
--- Start of Message ---
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)
Could anyone help me with the following @ all?
--- Start of Message ---
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)