+ Reply to Thread
Results 1 to 4 of 4

chart with ranked words only

Hybrid View

  1. #1
    Registered User
    Join Date
    02-23-2009
    Location
    LA, CA
    MS-Off Ver
    Excel 2007
    Posts
    2

    chart with ranked words only

    Alright.

    I have 14 columns with 25 words ranked in each column 1 thru 25. the words in each column are repeated through out the columns but at different ranks and order.

    What I need, is a way to chart the performance of these words, time they were repeated in throughout the 14 columns, etc..

    HOW!!!!!????? If the attachment loaded okay, that's the data.

    daryl@mb2raceway.com
    daryl@mb2raceway.com

    Daryl
    Attached Files Attached Files
    Last edited by NBVC; 02-23-2009 at 05:35 PM. Reason: removed unnecessary commentary within thread title

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,374

    Re: chart with ranked words only

    What I need, is a way to chart the performance of these words, time they were repeated in throughout the 14 columns, etc..
    Huh?

    Charts are used to display numeric data in graphical format. Your file has words, no numbers. What do you want a chart to show, exactly? This needs more explanantion.

    cheers

  3. #3
    Registered User
    Join Date
    02-23-2009
    Location
    LA, CA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: chart with ranked words only

    okay, i understand your comment but request that you look at my spread sheet. I have listed my 25 top keywords for pay per click advertising and want to analyze their repitition and rank according to their placement. Obviously, mb2 raceway (according to the spread sheet) is going to hold the highest value since for 14 campaigns running it has place 1st and has repeated is presence for 14 campaigns. I was a chart that can show this. I understand that charts are created from values, so I need a way to create values for these words because of their rank and the number of times they are repeated. Please help.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: chart with ranked words only

    I'm not sure what you're trying to do either. Maybe this will get you started.
    Attached Files Attached Files
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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