Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating a Cumulative Data graph from Monthly Sales Data

Status
Not open for further replies.

audenino

Programmer
Jul 11, 2000
2
US
I have a table listing monthly sales data for each of our products.&nbsp;&nbsp;<br><br>example:<br><br>Product#&nbsp;&nbsp;&nbsp;&nbsp;Fscl_Month&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;K$&nbsp;&nbsp;&nbsp;&nbsp;Units<br>========&nbsp;&nbsp;&nbsp;&nbsp;==========&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;==&nbsp;&nbsp;&nbsp;&nbsp;=====<br>Prod A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;199911&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;27&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2<br>Prod B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;199911&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1<br>Prod A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;199912&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;25&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2<br>Prod A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;200001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1<br>Prod C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;200001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;35&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3<br><br>I want to create a chart that shows a progressive YTD total, by month, for a specific Product #.&nbsp;&nbsp;Any suggestions for how to proceed?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top