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:
Avg Orders By Hour shows the count of orders for each hour of each day for the last 6 weeks and includes a Grand Total row that shows the average number of orders for each hour of the day
Orders By Hour By Day shows the graph with the count of orders for each hour of the day
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?