Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as formatting, chart type, titles and legend.
"A picture is worth a thousand words"
1. Make a query to show what you want on the X-axis (Category) and Y-axis/es (Values)
2. Create a Chart object on a form or report using the Chart tool
3. Follow wizard steps, but don't worry about the data
4. Set the RowSource for the chart object to be the data that you want
5. Resize and Format the chart -- and set/change other properties such as text for Title(s)
6. To progammatically modify the chart, watch the next video in this series, 'Manipulate Graphs in Microsoft Access using VBA'.
Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.
Charts are easy to insert manually but sometimes we need to automate the chart insertion and most of the people find it difficult to control the chart creation and its properties via VBA In this article, we will learn about how we can use VBA to in…
Does your PST file get corrupted? Looking for a solution to quick fix corrupt PST file of Outlook 2016, 2013, 2010, 2007? Read this post to learn about some tips & tricks to repair corrupt PST file in Outlook.