Search results

Hello everyone I have some data from my local amateur archaeology society. From a dig, they have some data, which is the X,Y,Z of the location (so scaled dimentionally), and also a frequency at this location. I am envisaging an X-Y chart, but X-Y-Z, with maybe a scaled bubble at the point to...

Thanks Hui All sorted now tpmbrian

That is it exactly Hui Thank you! Can you tell me how you did it please? tpmbrian

Hi I have a set of X-Y co-ordinates representing positions of features from an archaeological dig, and have several features that I want to chart together, to show a plan of the findings. Feature1, Feature2, Feature3 X1 Y1 X2 Y2 X3 X4 2 0.1 2.3 0.7 3.1 0.8 2.2 0.3 2.4...

Narayan Amazing, I have downloaded the revised workbook, AND found the properties. I can see I need to do a lot more work to make this a part of my toolbox. Thanks very much for your excellent help. When I find time, I will revisit your revision, and research the VB code (unfamiliar territory)...

Thanks Narayan I can't seen to get into the slider properties, otherwise I would have a much closer look at this solution. From my limited skill, I might be tempted to discard the pointer if I could embolden the active question when the selection slider made it active for the input. I could...

Hi Narayan Following your prompt, I went back to your link, and downloaded the file, and gave several permissions, then I was able to open up your excellent solution. It does pretty much what I wanted it to do, thank you. I am not sure if I can develop this to fit my profiling spreadsheet...

Answered my own question, custom format ddd dd/mm/yy The power of a large Martini helped change my focus.

Hi I have a chart which has on the horizontal axis dates from a row of data. I can post underneath the day of the week. I have tried to concatenate them but all I get is day of the week and the date value. Can someone tell me how to get for example Sun 11/3 for the axis value? Thanks

Everyone, my apologies, I left the question not expecting any serious response, so I did not see your inputs until now, so here are my collective answers. Faseeh, yes, scroll down the questions, and use the one slider to score each question as they are selected. Narayan, 1-scroll down to the...

Hi I have a challenge, which is on my wish list, and not critical to my progress, but seeing as how you talented people have always risen to great heights to help me, I thought this might engage your imagination. I have a spreadsheet which is profiling Emotional Intelligence and looking at how...

Narayan Excellent, that has worked on the test sheet, and on the actual sheet. What a converluted way to solve the problem. Excel 2010 continues to give me cause to wonder as I discover more intricate routes to simple commands. I used to think I was a power user, not I rank myself as one step...

link to file https://rapidshare.com/files/981874194/slider.xlsx thank you

I've uploaded to rapidshare, but now what?

SirJB7 Can you tell me where/how to upload, and I will do so as soon as possible. Thank you. Brian

SirJB7 Thanks for the response. As I said in my question, I have tried with some of the sliders locked, and others not locked. On the protected sheet it makes no difference, they are all protected. I think I am looking in the right place, it is Developer mode in 2010, that I have unchecked the...

Hi I have a spread sheet that works as I want it to, and it has protection, allowing users only to input data into specific cells. I have now added a slider bar beside these input cells, but using format control having them locked or unlocked does not seem to allow the user to access these...

Narayan That is a real good solution, I will use the MIN function to select the nearest job role. I will later, after we have acquired enough data, make sure the match is within a tolerance. I actually only need the sum of the difference squared, as there are the same number of parameters for...

Hi I am working on a personnel appraisal project. Candidates fill in a questionaire, which eventually creates a profile, say A=4, B=3, C=2, D=4. I have a selection of job profiles for say Engineers (4,3,3,2) or Sales (2,3,2,5), and I want to Identify which job profile most closely matches the...

Thanks Asa That worked Brian

Hi I use this function, which works when I put into the last criteria the text value, in this case Electrician, but when I put Electrician as data into B38 it does not work. =SUMIFS(H10:H34,H10:H34,"=1",$F10:$F34,"$B38") Can someone tell me what is wrong with the syntax for the second...

I find that paste as enhanced metafile usually keeps the image charactertistics, and if in power point you need to resize, hold hown the shift key to maintain the aspect ratio ie keep the pies round TPM Brian

I have a table of data, weekly entries as follows week 1 week 2 week 3 week 4 week 5 week 6 week 10 etc Plot Availability 50 56 58 45 50 60 Performance 40 42 41 20 45 50 Yield 90 92 93 75 91 90 95 OEE 18.0 21.6 22.1 6.8 20.5 27.0 36.6 In the plot column I want to insert either the...

Brilliant Just a question of knowing the tick boxes exist, and where. Thank you Hui and Chandoo. I am working on my negative values in a pie chart next. Brian

I have rows with formulae I want to hide, but still show the results on a chart. Is this possible?