Search results

Hi all -- I have a situation where in Cell A1 there is a set value. When I enter a value into Cell A2, I need it to lookup a chart of values determined by a range for instance 0 - 50,000 gives a multiplier (acting on cell A1) of 0.80, 50,001 - 100,000 gives a multiplier of 0.70 100,001 -...

thanks:)

Please refresh me -- how do I convert it to a table?

Hi all -- I have a workbook that has 30 tabs, each worksheet represents one day of the month and is basically the same throughout, though some worksheets have extra rows000. Each worksheet has approximately 450 rows and in column G product information is recorded if a certain product (shown...

Hi Luke -- No, we could do something like 3 in a row green, 4 in a row yellow, 5 or more red; that would be cool. LCD

Hi all -- I have a spread sheet with individual's id number on the left column and test scores (if available) under each month. I would like to automatically color the cells if 3, 4, 5, etc. cells have a value entered in a row. (see attached) I have played a little with the information...

thank you much that should do it:)

Hi all - I have a rather large spreadsheet with LOTS of equation. I would like to email just one worksheet to a client with no equation available and only the numbers / values in the cells. Any thoughts? thanks Lawrence

Hi all -- I have a spreadsheet with some attached graphs. I thought if I made a copy of the spreadsheet then the formulas for "select data" would be for the new sheet instead of the master copy, but it keeps using the master copy to generate the graphs. Any thoughts on how to make the "select...

Every month I copy a large spreadsheet with 8 charts created by the monthly input. My question is I would like to have the charts on a seperate sheet so that I don't have to scroll to the location of the charts to print. How can I make a data sheet and chart sheet that are created at the same...

thanks Hui that was the trick, now I just have to convert 5 spreadsheets to that (yikes) and thanks Luke for trying (that is the correct set up)

Hi all-- My co-worker asked me if I could come up with a good way to chart some data. Here is the scenario: We run four shifts and are trying to graph "# of units ran" and also (separate chart if necessary) "lbs of product ran" per shift in a month's time then a chart with the totals of each...

Hi Luke-- thanks works well now:) LCD

Hi all-- I am trying to build a graph of total time our machine is down per week. In column A I have the different weeks ie 20 May - 26 May, 27 May - 2 Jun, etc for the last 2 months. In column B I have the total times (summed from another part of the sheet). My problem is that when I try to...

Thank you stemelliott and Chandoo (I am honored you picked my question). As soon as I get a chance I will play with these and see what I and come up with, unfortunately Chandoo the time range is 24 hours so it won't be as neat and tidy as I (and you) would like to see it. LCD

Hi all-- I am trying to determine busy times vs. slow times. I have a spreadsheet that has 1 Oct to 27 Dec as column headers, each column as a list of times that a test was done on that day. Some days the test was run 5 times, some day 100 times. I am trying to graph what times are the most...

Hi Hui-- thanks for the help. We tried to enter Fruit into the Criteria Cell D2 and it didn't work. Any thoughts? LCD

HI Luke-- Thanks for you forensic analysis of the fruit / vegetable question. My question is this: what if you wanted to list the fruits instead of the vegetables? My colleague and I tried changing the criteria and nothing, tried making the < ROWS into > ROWS and still nothing...

I will be using a pivot table, I think. I just would like to figure out why the formatting is goofy using this equation. I have other equations connected to the first column of reasons and the graphs just flow naturally. I highlight the two columns, hit insert and presto -- I get a useable...

thanks all, it's just goofy but I will keep playing with it:) LCD

Hi all-- Thank you for your help last week on finding sub totals from a huge list. I got =SUMIF($I$5:$I$66,$N38,$H$5:$H$66) to work as far as giving me the times of each category, now when I try to insert a graph from this information, I just get the total time for everything in one bar...

I think that is on the right track, I still am struggling with the time format, but I will keep plugging away at it. Thanks again all LCD

prasaddn your time format didn't work, for what should have be 5 hours 20 minutes, the chart is given 96:00:00, any thoughts? LCD

somewhere over the rainbow.... yeah I figured but where is the table? There is a chart next to the graph that has Count of Total, but I can't figure out how to change that.

Hi Luke-- How do I edit the pivot table when I made a pivot chart directly? LCD thanks prasaddn for the hint about the time format