Recent content by tpmbrian

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