Home |
Search |
Today's Posts |
#1
|
|||
|
|||
3 month rolling chart
I've looked at some examples but found myself lost. I have a sheet that
shows overtime by department (those being the rows) by month (columns), and wanted to make a chart that will show a rolling three months for each department, so it would show August, July, and June, and next month Sept, Aug, July. I know I have to use the Name function and Offset in some terms but am somewhat lost. The department names start in A7 and go down, the months start B4 and go across. Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Z Chart i.e. top rolling annual bottom rolling monthly middle cum. | Excel Worksheet Functions |