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...

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...

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

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...

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...

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...

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 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...

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

Has anyone found a novel way to show profit/loss on a pie chart IE Year 1 Pie chart turnover £25M Profit £-5M Year 2 Pie chart turnover £30M Profit £4M Also, can the diameter of the pie be scaled to say the turnover value? This is my first post, so be lucky!