Search results

Thanks Hui!

Say I have a bunch of numbers that I want to find in my excel spreadsheet, like the following; 27001407 27001436 27001438 27001439 27001440 27001464 27001544 27001545 27001547 27001548 27001549 27001564 27001570 Is there anyway for excel to find all these for me at once instead...

Sam, Thank you so much! This worked perfectly!!! :D

Hi everyone, I'm currently making around 100 scatterplots for a set of data; is there anyway for excel to automatically make these for me instead of me creating each graph one by one? Here's the link to the data on dropbox for reference...

Hi SirJB7, Thanks for the help, I really appreciate it! (:

Sure thing! here's a link for just a little sample of what i have : https://www.dropbox.com/s/0idba1416bwk8un/Workbook12.xlsx and when I issued "?chtobj.Name, I", it identified "Sub Add_All_Trendlines()" as the error. What exactly does variable not defined refer to? thank you!

Hui, I'm currently using excel for mac 2011, does that have anything to do with it?

Hi SirJB7! a. Yes b. Yes c. I tried and it didn't fix the situation. Any other ideas? Though it would be a lot easier for me to upload the file, I unfortunately can't because everything on it is confidential.

SirJB7, For one of my spreadsheets, the code worked perfectly, but for another spreadsheet, I got a popup from excel saying "Compile Error: Variable Not Defined". Does anyone know why/what I can do to fix it?

thank you SirJB7 (:

Thank you, I appreciate the help :D

Thanks Hui, you've saved me so much time!!! Also, is there a function in excel that can automatically pick up trends (upward, downward, horizontal) and categorize them for me?

Hi all, I'm looking at roughly 200 graphs on a single spreadsheet, is there a option in Excel where I can add a trendline to all 200 at once, instead of doing it graph by graph?

Hui, My problem was inserting a row to the right and between each currently filled cell, hence the "staggering". I simply used bobhc's trick, the 3rd post.

Thank you all for the help, I have it all sorted out now :D

Hi all, Is there a way to stagger cells in an excel spreadsheet? I'm looking at a bunch of differences and a staggered setup would make it much easier on the eyes. This is an example of what I want it to look like: 12 13 21 16 with a cell between 12 and 13, 13 and 21, 21 and 16, etc...

I'd really appreciate it Narayan thanks! and Hui, I'll try your Pivot Chart idea and see how it works(:

Thank you Hui and Narayan Thank you, but unfortunately my file is for business, and therefore, confidential. Is there a code I can write to simplify the process? This is what I have right now: Sub Graph() ' ' Graph Macro ' creates scatterplot ' ' Keyboard Shortcut...

Hi everyone, I'm analyzing a huge set of data and I was looking for a function on excel that would help me greatly in speeding up the process. For example, I have this set of data: Serial Number Date Measurement 2600 4-3-13 12 2600 5-12-13...