I *HATE* Access charts, I always have so many problems with them it seems. If you're unlucky like me and it doesn't work out, you may be better off exporting the data to excel for the chart or making your own graph. I know for any bar charts I make now I just make my own using the same technique in the Progress Bar Form Completion video. Way more control over it and looks better in my opinion. You may be able to toy with it into looking more like a line chart with adjusting the size of the controls if you had to have a line chart.

But to try and troubleshoot your problem, what have you not been successful in doing? Is there any errors coming up or showing the wrong data? Need some more information of what's wrong.

Thanks for the response Adam.  I'm with you on the Access charts and was considering your Excel suggestion.

I think the root of my problem lies in the Time field.  In my Transaction table, the time data shows up as a time, say, 5:24:29 PM.  To get the last transaction of the day, my query contains the transaction Date, the MAX of the transaction Time and a day of the week field so I can exclude Sundays.  Even though the Time field shows the Time only, I think the underlying data also contains the Date (my Time/Date knowledge needs work).  

When I create a Modern Chart based on my query, I can get the Date along the X Axis but on the Y Axis I'm getting numbers with decimal points.  I have attached an image of where I am so far.  Obviously it needs formatting and dressing up, but it shows the issue.

I have a feeling that it's something basic and I'm going to feel "dumb" when I find out!!  Anyway, thanks for taking a look.

At the risk of being wrong (because I don't do graphs much, take it with a grain of salt, shooting from the hip). I believe the decimals are just how access shows the data by default with small numbers (you have a value of 1 and it doesn't want to just show one number to the side). It looks like all the values area at 1 because its' set to Count. What happens if you set it to Max instead (or none?)

I changed the settings as suggested.  Result and image of chart settings attached.  Weird.

So that steady increase leads me to believe the value is  including the date. New day the numeric conversion of the date goes up a little bit steadily along. Can you confirm or try to remove the date value and just have the time value?

I think you would want to make the Y axis be the time only field (no date). You may need to remove the date portion manually. You can do that in the query by doing like

TimeOnlyVersion: TimeValue(TimeFieldNameHere)

OK!  We're making progress.  I think the primary axis is working correctly now BUT the time of day is (I believe) being displayed as a fraction of the day.  0.7 (for example) * 24 comes out to 16.8 or around 4:50 pm (I haven't done the precise math on that).  Do you think that's what's happening now?  If so, I haven't been able to make those decimals show up as a time of day yet.  Images attached.

Yea I'm pretty sure that's what's happening now. I've spent like 20 minutes trying to get it to stop doing that using different formats/cdates to try to keep the values the same but it always wants to return to a percentage of the day. And there's hardly any options inside the modern charts it seems compared to the old ones. I'll try a few more things but this is normally when I would throw the chart away and go to excel or try to think of something else custom ;).

If I need graphs, I definitely consider doing that on Excel (manually or with VBA), and use Access only as a back end.  Excel is clearly the superior tool for graphs.  I would record a macro in Excel of me making a graph and pulling data from Access, then I would tweak the resulting VBA code to my liking.

Yes!  We're on the same page!!  Thanks so much for your help!  I'll mess with it a little more just for giggles and then it's on to Excel.  Bummer!

Yeah, I honestly will use Excel more than Access. The only thing I use Access graphs for are simple little "dashboard" type graphs to see some simple stat like monthly sales. Anything serious goes to Excel. It's a shame that Microsoft hasn't put the cool features from Excel into Access, but... oh well...