Search results

Thanks a lot JHB, that did the trick. I was stubbornly trying to find a solution within the row source query of the graph and neglected to think of stand alone query solution. I'd prefer to use the new graphing method within the 365 version but at the moment only one computer has it...

Ok, I've set the column heading in the crosstab query for the date field. But in order to get the date field on the x axis I have to reorder the graph 'by row' within Microsoft Graph which gives me the same result as before. What am I doing wrong?

See attached a database which outlines what I discussed earlier. With this fictional example I need all dates from Feb to Sep to display on the x axis regardless if the value is zero. 'QueryTest' has missing data - the graph crosstab query in the row source fills it in (if that makes sense)...

Thanks doc man. By double clicking the graph I enter Microsoft Graph where I can select the table option to be able to view the numerical data beneath the graph. The column of all zeros (the last column in the data set) does not appear within the graph/table at all. I should note that this is...

Hi, If I attempt to create a line graph based on a query that has a column or row that is all zero's then this column/row will be absent from the resulting graph. How do I force a graph to plot columns/rows that are all zeros? BTW, this is not an issue with the 'new chart' method in Access...

Hi, I'm John from Australia, I've been an access user for about 8 months now. Cheers.