Microsoft
Thank you for your response.
To test what you said, I downloaded the query I was trying to graph and then uploaded it to a table.
And as you said, I was able to graph it using the new Chart and selecting a Legend along with Axis (Catergory) & Values (Y axis).
It graphed as expected.
So I guess the issue may have something to do with the chain of queries I'm using to create the data in first place.
I've designed it to filter in three steps, where step (0) is the raw data in a table.
(0) raw data
(1) Query that is a straight "Select" query where I'm joining 4 tables and filtering on 5 specific fields that the user defines by use of a form. For some of the defined fields, there are multiple (7 or 😎 filter choices.
(2) A second query, with only the 1st query as input, that uses "Totals" functionality in the query and generates some flags that I use in the final query for manipulating the data.
(3) The third and final query, also using the "Totals" functionality, is built off of the second query that is joined with one table to force a specific ordering of what will be displayed on the graph. There is also a number of DSUM calcuation I do in the query.
I then place a chart on a form and select the 3rd query as input.
As soon as I select an item for the legend, the graph blanks. Even if I switch to "Form" view. The chart is blank.
I can go into the the query created by the chart (Select the chart, view properties, select "Data" tab on the properties sheet, and then select "Transformed Row Source". That brings up the query created by the Chart.) And I can see all the data is generated correctly as expected.
But the chart for some reason is unable to display it.
Seperate question related, I noticed you some how put a graph onto your response.
In my initial response, I tried to past a screenshot into the comment, but it didn't seem to take.
How do I put graphics into the comments?
Thank you for your time.
