+ Reply to Thread
Results 1 to 9 of 9

Excel Charting for SEO Rankings [Visual]

  1. #1
    Registered User
    Join Date
    11-02-2014
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    5

    Excel Charting for SEO Rankings [Visual]

    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
    Last edited by hemanthjava; 11-03-2014 at 06:21 AM.

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13
    Posts
    953

    Re: Excel Charting for SEO Rankings [Visual]

    I can't view your png files, pls redo.

    & have you got a file you've been working on?

    Pls post it to the forum.
    Remember you are unique, like everyone else

  3. #3
    Registered User
    Join Date
    11-02-2014
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Excel Charting for SEO Rankings [Visual]

    Quote Originally Posted by noboffinme View Post
    I can't view your png files, pls redo.

    & have you got a file you've been working on?

    Pls post it to the forum.
    Image Links for the first and second are placed below;

    Direct Link of the 1st Image - http://i60.tinypic.com/2zqfuyf.png

    Direct Link of the 2nd Image - http://i58.tinypic.com/2m5nqma.png

    Please find the link to the Excel working sheet here - http://iptltennis.net/ranking.xlsx
    Last edited by hemanthjava; 11-03-2014 at 06:20 AM.

  4. #4
    Registered User
    Join Date
    07-28-2012
    Location
    India Chennai
    MS-Off Ver
    Excel 2013
    Posts
    11

    Re: Excel Charting for SEO Rankings [Visual]

    Unable to find the excel file. Please redo
    Saravanan R 09940016098 rsaravan@comstarauto.com

  5. #5
    Registered User
    Join Date
    11-02-2014
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Excel Charting for SEO Rankings [Visual]

    Apologies.. Please find the link here - http://iptltennis.net/ranking.xlsx

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,831

    Re: Excel Charting for SEO Rankings [Visual]

    Sheet1 contains pivot table/chart based on your source table.

    Sheet2 contains same thing but based on data table with alternative layout.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  7. #7
    Registered User
    Join Date
    11-02-2014
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Excel Charting for SEO Rankings [Visual]

    Quote Originally Posted by Andy Pope View Post
    Sheet1 contains pivot table/chart based on your source table.

    Sheet2 contains same thing but based on data table with alternative layout.



    Hi Andy,

    Thank you so much for your help. I have one question though. What steps do I need to do in order to get from my source table to your table in sheet1?
    Apologies if this is a very basic question but I am new to pivot tables.

    Many thanks for your help.

    Regards
    Hemanth

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,831

    Re: Excel Charting for SEO Rankings [Visual]

    As the file you posted was .xlsx I will assume you have excel 2007 or newer rather than the 2003 in your profile.

    with the activecell inside the data table use the ribbon Insert > Pivot Table.
    You can then drag the field items in to the row/column/page areas to construct the table.

    for much more information on pivot tables see Debra Dalgleish's site
    http://www.contextures.com/tiptech.html#Go_P

  9. #9
    Registered User
    Join Date
    04-10-2021
    Location
    Unitd Kingdom
    MS-Off Ver
    MS Office
    Posts
    1

    Re: Excel Charting for SEO Rankings [Visual]

    Thank you share this nice information.
    https://planetaryaccountingandmarketing.com/

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. converting weekly rankings into monthly rankings
    By sfinns in forum Excel General
    Replies: 6
    Last Post: 02-09-2012, 08:51 AM
  2. identify rankings according to gender - Excel VBA
    By Michael007 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-24-2011, 11:19 AM
  3. Can Excel do rankings?
    By cbnbac in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-27-2008, 08:48 PM
  4. Excel Rankings function
    By Crash1 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-25-2006, 11:00 PM
  5. Custom charting - Stacked charting with a line
    By Randy Lefferts in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-03-2005, 12:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1