Hi,
I'm trying to create a combo graph. I have a list of terms (baseball bat, baseball, glove, baseball jersey etc) and I want to be able to compare their monthly sales to the month search volume.
How would be the best way to organize the data so that I could create a combo graph that would show sales vs search volume for each month for each item? I'm guess this would need to be done in a pivot so that you can filter through the items and view each one at a time.
thanks.
I also posted this at:
https://www.excelforum.com/excel-ge...aph-how-to-organize-the-data.html#post4892947
I'm trying to create a combo graph. I have a list of terms (baseball bat, baseball, glove, baseball jersey etc) and I want to be able to compare their monthly sales to the month search volume.
How would be the best way to organize the data so that I could create a combo graph that would show sales vs search volume for each month for each item? I'm guess this would need to be done in a pivot so that you can filter through the items and view each one at a time.
thanks.
I also posted this at:
https://www.excelforum.com/excel-ge...aph-how-to-organize-the-data.html#post4892947
Last edited by a moderator: