Hey guys,
Have a quick question that's bothering the hell out of me. I've created a pivot table in excel which I was graph but it has 3layers of data I want to show. On the y-axis I have frequency, on the x-axis I have 3 categories and the data is spread out over different months.
Right now it's showing the graph (bar/line) where it divides into months and then months are divided into the three categories over and over.
I want to eliminate that and have the graph show only categories on the x-axis and months show seperately.
What type of graph should I use?
Thanks!
Have a quick question that's bothering the hell out of me. I've created a pivot table in excel which I was graph but it has 3layers of data I want to show. On the y-axis I have frequency, on the x-axis I have 3 categories and the data is spread out over different months.
Right now it's showing the graph (bar/line) where it divides into months and then months are divided into the three categories over and over.
I want to eliminate that and have the graph show only categories on the x-axis and months show seperately.
What type of graph should I use?
Thanks!
