Do you want to know how to manipulate graphs and charts in VBA using Access?
Hi, this is Crystal
I will show you how to change data for a graph, set the chart title, x-axis title, and modify scales and formats.
We all love graphs.
This is a graph with Microsoft Access.
Here is the menu form that generates the graph.  It is called f_Graph_Menu.
Graphs are not very well documented so I hope this will serve as a good example.
Let me explain the data sets to you.
I've created 2 tables.
One has a date/time. which is truncated to a date for graphing purposes,
and a value.
Beyond that, the data is related to a topic.
Not in this dataset are related tables.
I'm just calling them OtherID.
In my graph topics, this is pretty generic -- 1st Topic, 2nd Topic, 3rd Topic, and so on.
The Topic is generally what you would want to put at the top of the chart.
I use the terms "chart" and "graph" interchangeably.
The button is labeled "Chart".
If I click on the Chart button and have chosen the 1st Topic, notice "1st Topic" is in the header of the chart.
If I put any criteria on, that will be in the footer.
I can see I have data from July ... well actually, I don't know what years those data are.
The date format is just month and day (mmm-d).  I also want to show the year so I'll change it to mm-d-yy.
This is for the X-Axis, which is also called the Category axis.
Now I can also see the years of my data.
Let me choose to look at data after July 2013.
On this date range, I can put 7/1/13 and click Chart.
Now that I am looking a little closer, maybe I don't want to start the data till September.
So I'll close the chart and double-click on the date.
I can move forward by month.
I can also put a date in here.
The calendar changes as you change the month and the year, or the day (you can also go a day at a time as well),
you can also click on a day on the calendar (these are done with command buttons).
All the code is behind this form so you can see how it works.
I'll pick another date and click OK.
Notice as criteria changes, so do control (values) on the right of the form.
The header is "1st Topic".
The footer has criteria for date >= 8/9/2013.
I can also filter for another criteria.
Here I will choose 10.
The criteria in the footer is recalculated and displayed.
The reason it is done this way, rather than calculating it at the time of the report, is so that you can change it.
You can say whatever you want. I will add "ANOTHER COMMENT".
Whatever you add is also displayed.
If you change ... more captions coming!   
