How to make a step-chart in Microsoft Access?

wish helps you The problem isn't the repainting of the graph. Most likely, the subform that you are using is retrieving data from a query or table.
You must update the values on the "datasource" object, which is providing the subform data (either a query or a table). Then, re-query the graph object in the mainform.

I hope this helps you . I have a Microsoft Access form which will display a Microsoft Word app with a blank document when a particular button is clicked using the following code : , After much trail and error, I've found the solution:

If Tasks.Exists("Microsoft Word") Then
   AppActivate "Microsoft Word"
End If

Does that help Reports don't refresh like forms, so if the chart is unbound you'll have to take care and place the code changing the row source in an event which occurs before the report is rendered like the Format or Print event. I'm assuming the IDs you're including in the SQL string are numeric and not strings.

This might help you Simply define the Series color with an alpha component
chart.Series["Default"].Color = Color.FromArgb(120, 0, 155, 155);