Solved

Cumulative Line graphs in MS Access

Posted on 2008-10-22
6
577 Views
Last Modified: 2013-11-28
Hi

What I have:
- a set of monthly returns in a MS Access. I've attached the Access table.

What I would like to do:
- In MS Access,
- create a cumulative graph showing how say a 100 USD would have grown over time by each of the monthly returns.  I've attached how I would do this in excel.

How would one do this completely in Access?

Thanks
Jann
Desktop.zip
0
Comment
Question by:tonikgroup
  • 3
  • 2
6 Comments
 
LVL 30

Accepted Solution

by:
hnasr earned 500 total points
ID: 22793420
Try this:
One approach, a function to accumulate the index is required, and written inside a module!
Access-x.zip
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22793781
tonikgroup,

I took a slightly differnt approach.

I generated and inserted the Index Field values directly in the Return Table itself, by using the code on the form named: frmGenerataData.

Then Plotted the chart directly from the table.

JeffCoachman
Access-BasciReportByOneFieldDate.mdb
0
 

Author Comment

by:tonikgroup
ID: 22794105
Thank you hnasr!

Jeff, It seems that you've uploaded the wrong file?

I never regret subscribing to experts-exchange!

Regards
tonikgroup
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22794377
tonikgroup,
   
    "Jeff, It seems that you've uploaded the wrong file?"
Yes but wasn't the file informative anyway?
;-)

LOL

Here is the real file (I hope!)

Jeff
Access-EEQ23836472GraphChartCumm.mdb
0
 

Author Comment

by:tonikgroup
ID: 22795077
Thank you Jeff!

Everything coming from your team is informative.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22798577
What was the deciding factor?
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question