Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-01-2015, 01:28 PM   #1
Infinite
More left to learn.
 
Infinite's Avatar
 
Join Date: Mar 2015
Location: USA Missouri
Posts: 402
Thanks: 67
Thanked 0 Times in 0 Posts
Infinite is on a distinguished road
Charts!

Hello. again. I have a report, and it has The month the item(s) was sold, to item(s) that were sold, and the Total sales for that item.
Now, what I want/needs to know is, how to I get a chart, per month, that has a overlay of each item per month. So, I can see that in 2014 we sold 200 items in may, and in 2013 we sold 146 in may of 2013. How do I set that up so I can see that information in a chart? Thanks!

Infinite is offline   Reply With Quote
Old 08-02-2015, 03:11 AM   #2
Isskint
Slowly Developing
 
Isskint's Avatar
 
Join Date: Apr 2012
Location: Wiltshire, UK
Posts: 1,301
Thanks: 124
Thanked 311 Times in 304 Posts
Isskint will become famous soon enough
Re: Charts!

hi Infinite

To do this you need to create a query that sorts your data by the Month and the Year. I generally add 2 fields (TheMonth and TheYear) using the Format() function EG TheYear:Format([Date],"yyyy").

Now you have to decide on mess or clarity (HINT - CLARITY )
It comes down to the number of data points. Say you have 4 products over 2 years. That is 96 data points. If you produce a single chart with all 4 products on it you would have 16 series which is messy. The better option is 1 graph per product. So create a report based on your query (so you have a Parent/Child scenario). Create your chart using Sales, Month and Year. Axis is TheMonth and Series is TheYear.

Have a look at the attached
Attached Files
File Type: mdb Charts1.mdb (396.0 KB, 42 views)
__________________
Isskint, i get satisfaction out of helping others
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Success is the sum of small efforts, repeated day in and day out
Isskint is offline   Reply With Quote
Reply

Tags
charts , charts by month

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
charts steve111 General 2 01-24-2015 01:40 PM
Charts Finks Forms 12 05-29-2003 10:42 PM
Charts dpw Forms 1 01-09-2003 05:07 PM
Charts aneats Reports 13 12-05-2002 05:54 AM
Charts chastst Reports 0 01-09-2001 05:20 AM




All times are GMT -8. The time now is 12:27 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World