I can use the Grand Totals to display average number of orders by hour of day but I'm having a really tough time getting the average into a graph. Can someone please help?
The attached workbook has 2 sheets:
Ideally I want to add a big bold line to the graph in Orders By Hour By Day that shows the numbers in the Grand Total row of Avg Orders By Hour. If adding the numbers in the Grand Total is not possible, how do I create a graph displaying the numbers in the Grand Total row in Avg Orders By Hour alone?