Update graph's usedrange, VBA

Hi there,



I am trying to update the range for the graph automatically and I'm calling this from Access because my data exists in Access. I've attached a sample file.



what I am trying to do:



1) click on the button

2) button will update the usedrange in "trending" tab

3) have the graph's data range based on the usedrange.



note: the columns will grow bigger to the right, which is dynamic, so I've used usedrange method, but the code fails on the usedrange line saying the object or method is not being supported...



Can someone help me?



Thanks

Attached Files

	test graph range update.accdb (440.0 KB)
	Metric_DEV.xls (11.1 KB)

Update graph's usedrange, VBA