graphs

[adrian335i]

How do i pot together a graph that shows me what my month end projection is according to my current sales and day left in the month for example i sold 20 units and we have 19 days left what would be my projected mt end sales be... thanks

 

[pbornemeier]

Create a column containing the dates for all of the workdays in the month
Use an adjacent column to show a running total of items sold
Insert a 2-D line chart of those 2 columns
Add a linear trendline