Recent content by thomasleitner

thx.. that worked well

a combination of a collum chart and a line

Hi, i have a diagramm with 365 values ( one for each day 2010). i like to set the x axis to only show me the months and not all the days. i tried changing the scale to a date axis- didnt work i tried setting the intervall to 30 .. -> doesnt work i tried several things on the microsoft...

hej guys, i have a small problem that i just cant wrap my head around.. i need a formula which provides me with a solution. i dont want a VBA script and as few as possible helper lines. the problem: i have several effects on a production . the start from 2011 on but some later. i want to...

@ xld... works perfect.. even though its a script and i was teh first time i used scripts :-) @kchiba.. i know thx.. i found a third way.. very basic.. well thats me:.-) i just can write it in the box as a text.. off course meaning that i cant put a error message in if someone types...

i mean validation.. i want to use it for a kind of dashboard .. i want the users to be able to select various variables . which connect to a sumifs function. the listvalues could be jan feb mar apr mai ... i name the list months and refer to it ( use another sheet) the cell i...

i know how to create drop down lists and use them a lot.. one thing i havnt gotten to work til now is to have a standard value in the list. meaning. i got a list of say 5 names. in the drop down list i would like it to say - "select a name" so the user is drwn to the field

thx.. works like a charm.. except i had to use to helper collums to get the time correct

no the units produced are at the time in the same row.. so 2010/09/01 05:04:00 (which seems to be a text unfortunatly-- so i need to convert it to a time i guess) i produced 0 units.. 2010/09/01 06:00:00 i produced 143 unit... i need to know from the time 2010/09/01 05:04:00 and 60...

sorry dont know what went wrong try this link https://docs.google.com/leaf?id=0B4cakkS8jEm9ODNkNGFkODUtODAzZS00MDdiLWFmZWYtNTk5ODAyYzdhNTZj&sort=name&layout=list&num=50

hej all, i have a issue which i need help with. i have two collums - collum A are the unit produced and collum B the time when it was produced. see sample file - the real file has 70000+ entries...