Create a graph from a Report that has sub totals

[Lateral]

Hi guys (I'm a newbie so please be kind )

Ok, here is the issue I have,

I have a report that I have created that counts the number of "Workorders" and sub totals them for each month of the year. I use the "Group by" option of the report function.

This works well.

I want to create a simple bar chart that displays each months sub total for a defined period of time...such as the last 12 months.

I have played around and just can't figure out how to do this....

Any help is greatly appreciated.

Merry Xmas!

Regards
Greg

 

[sneuberg]

https://www.youtube.com/watch?v=YhgNX6BWWmk looks interesting.

 

[Lateral]

Hi guys!

I just had a cup of tea and then came back and had a play around with Pivot charts!

I got it working!

Regards
Greg

 

[Lateral]

Thanks for the link.

I managed to create a Pivot chart and it works fine whilst I am in developer mode but when I switch it to runtime mode, when the button is clicked to activate the form, I do not see the pivot chart...it displays in single record format....

This is the code I am using...

Private Sub All_Valid_Workorders_by_Month_Graph_Click()

DoCmd.OpenForm "Copy Of rWorkorders All Valid by Month", acFormPivotChart

End Sub

Also, the default view of the form is set to Pivotchart

Help!

 

[Lateral]

I'm using 2007 as my development environment and 2010 a the run-time when I deploy it.

I'm also testing it by simply renaming the accdb to accdr and it doesn't work then as well.