Why doesn't the chart display the data from the query as expected?
I have attached the Access database. I cannot figure out what I thought was a simple chart does not display the way I expected it to be.
If you look at Form1, I had a simple chart based upon a Query. (MonthChartList) If I look at the property of the chart on Form1 and look at the Row Source, it appears to me that the query is running correctly. Why doesn't the chart show me the correct Month/Year found in the query column
labeled Expr21? I assumed that the results of the query would display on the chart as
Oct 2018, Nov 2018, Dec 2018, etc. What is the chart doing? Ultimately I need to display Open Sales Dollars for any given Month/Year that the query has for results.
Thanks in advance for any help!
RG OpenSales-.accdb
Hi Gustav,
I saw your example. Absolutely great! Thank you for your quick response. Rather than just using your solution, I tried to re-create
yours. I created a query called MonthChartList_2 and used your suggested code.
I created the chart on Form1. What am I doing wrong? It does not come out in the format you have. What am I not seeing?
I intend awarding you for your solution to my problem but as I said, I just do not want to copy and paste your solution without understanding what the heck I am doing wrong. I have attached my file again. Would appreciate you taking a look.
It looks similar to me. You have another format on the Y-axis and a thicker font, but I didn't touch those - only the query was modified to sort on the YYYY-MM value.
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
ASKER
I saw your example. Absolutely great! Thank you for your quick response. Rather than just using your solution, I tried to re-create
yours. I created a query called MonthChartList_2 and used your suggested code.
I created the chart on Form1. What am I doing wrong? It does not come out in the format you have. What am I not seeing?
I intend awarding you for your solution to my problem but as I said, I just do not want to copy and paste your solution without understanding what the heck I am doing wrong. I have attached my file again. Would appreciate you taking a look.
Thanks again!
RG