Hi there,
I am trying to represent detailed datewise performance for a month in 2017 for same time 2016.
I am not able to create them directly using pivot chart.
I have attached raw file in screenshot1 in the word file attached.
I have to create data for july 2016 and july 2017 individually as in screenshot 2 and 3.
And then in I have to combine them as in screenshot 4 to get the graphical view that I have represented.
I want dates on any one axis vs rev for 2016 and 2017 on other directly from a pivot chart. I also want to shade weekday and weekend with different color on the graph.
Please suggest how to do it directly from my raw file
I am trying to represent detailed datewise performance for a month in 2017 for same time 2016.
I am not able to create them directly using pivot chart.
I have attached raw file in screenshot1 in the word file attached.
I have to create data for july 2016 and july 2017 individually as in screenshot 2 and 3.
And then in I have to combine them as in screenshot 4 to get the graphical view that I have represented.
I want dates on any one axis vs rev for 2016 and 2017 on other directly from a pivot chart. I also want to shade weekday and weekend with different color on the graph.
Please suggest how to do it directly from my raw file