Hello. I have a list of 30 days in a month. Typically the most volume is Mondays and the least volume is Saturdays and Sundays. When I create a chart, it really just highlights the up and down weekday/weekend spike. I'd like to see how the average is moving throughout the month. Is there a way to do this with excel? Spreadsheet attached.
Add a "trend line"?
How do I do that mate?
Actually, I figured it out. Can I get it to show numbers? The problem is that the range of values is so large that the trend lines doesn't show much except for that the average # of work orders is decreasing throughout the month.
Right click the data series on the graph you have (the blue line) and select "add trend line"
To show the numbers right click the data series and select the option above trend line. I forget what it's called right now....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks