Avatar of ES-Components
ES-ComponentsFlag for United States of America

asked on 

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
Microsoft Access

Avatar of undefined
Last Comment
ES-Components
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of ES-Components
ES-Components
Flag of United States of America image

ASKER

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.

Thanks again!
RG
OpenSales-.accdb
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

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.
Avatar of ES-Components
ES-Components
Flag of United States of America image

ASKER

Thanks for your help and explanation Gustav!!
Microsoft Access
Microsoft Access

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.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo