How can I make charts of *median* Ys for X ranges in my Access DB?

D

Donald Pirl

My Access 2003 parameter querries calculate price deltas for about 8000 stock
prices in two tables of stock prices at different points in time. I am
currently using "Top 50%" to find the median percentage increase (or
decrease) for each range of values. I want to create a chart that shows the
median % price increase for $5-10 stocks increasing in price, the median %
price decrease for $5-10 stocks decreasing in price, the same for $10-15
stocks, etc. How can I do this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to skip cells in column for charting 2
Excel 2007 Stock market Charts 3
How can I get the median of the numbers in an Access Report? 3
Increasing a price by % 2
lillana 0
How to create a chart showing ranges of prices of different produc 9
Slow VBA module in small Access DB 3
How do I create the formula for this calculation? 1

Top