Nick has attended:
Access Introduction course
Graph
Hi
I have a series of graphs for which the underlying data is updated each month. I do not want the graphs to pick up "empty" months so am currently manually changing the 'source data' each month to add the new months data - is there a way that the graph can automatically identify that there is a new months data and automatially update the source data in the chart or does this task have to be performed manually each month?
Cheers
NICK
RE: Graph
Dear Nick
Thank you for attending Access Introduction!! I hope you enjoyed the course.
Please find uploaded file for your reference.
It is important to note that the chart and the source data are linked to each other. This means that the chart gets automatically updated if you add or amend the data in the spreadsheet.
On the uploaded file you
Monthly sales Chart.xls
