I am currently using a pivot table called "QNs" where columns are called start Date, qty, description, etc. I am able to convert the data based on start date to a count by month and year and show the results in a graph. Is there a way to add an average column based on years to show ahead of monthly results using the pivot table? This is currently what I have from the results with "Row Labels / Count of date Submitted.
For the sum of average I used the main source table data from "QNs" and created the following:
How can I combine both of these count / average into one graph? I have tried to use relationships in excel, tried to add a column to add it to the current pivot table and am still getting no where. below is what I am needing it to look like. If I am not to use a pivot table how would I have a normal column graph count each date and place it in the correct month and be able to use the date and graph it.?
For the sum of average I used the main source table data from "QNs" and created the following:
How can I combine both of these count / average into one graph? I have tried to use relationships in excel, tried to add a column to add it to the current pivot table and am still getting no where. below is what I am needing it to look like. If I am not to use a pivot table how would I have a normal column graph count each date and place it in the correct month and be able to use the date and graph it.?
