Is creating a compound line graph possible with this dataset?
May 31, 2012 2:59 AM Subscribe
Is creating a compound line graph possible with this dataset? If yes, how? If not, how should I set up the data?
posted by chillmost to Computers & Internet (3 answers total)
I have an excel table with data formatted like this:
This represents the date on which a sale occurred and the country in which it occurred. Please note that the same dates often occur because there were multiple sales on this date.
I want to create a compound line graph with the date in the x-axis, and the number of sales that occurred on that date, compounded into what country the sales occurred.
Is this possible with the dataset and format that I have here or do I need to split it up, reformat it another way?
Would it be easier to graph the 2 values separately and somehow combine them together?
I've tried a few things like pivot and COUNTIF but my excel knowledge is a bit limited.