Hey all - I've created a simple chart that plots out the average of a certain value for each month. Works fine, but if no values were entered for a specific month, there is a gap in the chart. Apparently there is a way to connect gaps in Excel (see the video below), but I can't figure out a way to do it in Access. I was under the impression Access and Excel use the same chart object, so is there a way to connect gaps? Looked around the forums a bit and I did not see this question addressed, apologies if it's been answered already.
https://www.youtube.com/watch?v=40Wd3Wafa0w