Apologies if this has been covered already, but couldn't find anything that worked!
Cols F and G on the DATA sheet calculate the months and values automatically, based on value and date set in the GRAPH sheet.
Following Worksheet_Change Code changes the Lowest Value correctly when the value in D36 changes (Highest Value is always D241) for the Y axis, but can't get it to use the First and Last months in Col F of the DATA sheet for the X Axis.
Second challenge is need to change the "fill" colour in the graph where dates are after the current month. So on the attachment as sent, the graph fill for dates in F2 - F70 should be blue, but from F71 - F210 it should be orange.
No clue how to arrange that.
All solutions, suggestions and alternatives to either issue welcome as ever.
Ochimus
Bookmarks