Hi all,
I have a pivot table with sales grouped by customer and by month/year. I want to compare customer X sales by month in 2011 to customer X sales by month in 2012. So, two data series: one for 2011 and one for 2012. How do I set up the data series on my pivot chart to differentiate between 2011 and 2012 sales figures? It's just giving me one long series spanning from Jan 2011 to Aug 2012. Does the entire table need reformatted to have separate columsn for 2011 and 2012 sales?
I have a pivot table with sales grouped by customer and by month/year. I want to compare customer X sales by month in 2011 to customer X sales by month in 2012. So, two data series: one for 2011 and one for 2012. How do I set up the data series on my pivot chart to differentiate between 2011 and 2012 sales figures? It's just giving me one long series spanning from Jan 2011 to Aug 2012. Does the entire table need reformatted to have separate columsn for 2011 and 2012 sales?
