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
Last edited by NBVC; 02-23-2009 at 05:35 PM. Reason: removed unnecessary commentary within thread title
Huh?What I need, is a way to chart the performance of these words, time they were repeated in throughout the 14 columns, etc..
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
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
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.
I'm not sure what you're trying to do either. Maybe this will get you started.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks