Hello,
I have data in the format shown in the excel below. Everyday I add the data for that date.
1.png
I would like to create the pivot chart/line graph with the dates on the X axis, the keywords as legend(please see desired output below). The line graph should update automatically when I enter the data for a new date.
2.png
Ideally I would like a keyword dropdown where I can select the keywords I wish to visually see rankings for.
Any help will be much appreciated. Thanks in advance for your help.
Please find the link to the Excel working sheet here - http://iptltennis.net/ranking.xlsx
Bookmarks