What is a glitch in the diagram
authormessagebredme
You can freely change the rank in the profile
Posted:
March 18, 2013, 1:34 pm
First name:
zero
Formulas, diagrams and a bit of VBA
Posted:
March 18, 2013, 3:53 pm
Call name: Dennis
Place of residence: NDS
guest
Posted:
March 18, 2013, 4:54 pm
First name:
bredme
You can freely change the rank in the profile
Posted:
March 18, 2013, 4:56 pm
First name:
zero
Formulas, diagrams and a bit of VBA
Posted:
March 18, 2013, 5:45 pm
Call name: Dennis
Place of residence: NDS
bredme
You can freely change the rank in the profile
Posted:
March 18, 2013, 5:57 pm
First name:
bredme
You can freely change the rank in the profile
Posted:
March 19, 2013, 3:04 pm
First name:
zero
Formulas, diagrams and a bit of VBA
Posted:
March 19, 2013, 3:25 pm
Call name: Dennis
Place of residence: NDS
bredme
You can freely change the rank in the profile
Posted:
March 19, 2013, 4:29 pm
First name:
zero
Formulas, diagrams and a bit of VBA
Posted:
March 19, 2013, 4:35 pm
Call name: Dennis
Place of residence: NDS
bredme
You can freely change the rank in the profile
Posted:
March 21, 2013, 9:43 am
First name:
You can freely change the rank in the profile
Posted:
March 18, 2013, 1:34 pm
First name:
Version: Office 2010  
Hello everybody, I currently have to create a fault analysis for server failures. My problem now is the implementation in Excel, I am already doubting whether this is even possible with Excel. I have the following data: Date, time of the fault, time of rectification I don't really care about the time of the fix ... This is what my diagram should look like at the end: Aim: Disturbance as a bar with time. If there is more than one fault on the same day, 2 bars. How do I do that, if it's even possible? I already have doubts about the labeling of the date axis. Excel automatically shows me 7 days as the interval. But I only want to have a date displayed if times are actually available. Thanks and regards Michael 
Formulas, diagrams and a bit of VBA
Posted:
March 18, 2013, 3:53 pm
Call name: Dennis
Place of residence: NDS
guest
Posted:
March 18, 2013, 4:54 pm
First name:
Version: Office 2010  

You can freely change the rank in the profile
Posted:
March 18, 2013, 4:56 pm
First name:
Version: Office 2010  
The important dates are the date and time. In order to show that something happened several times in one day and at what time it happened. 
Formulas, diagrams and a bit of VBA
Posted:
March 18, 2013, 5:45 pm
Call name: Dennis
Place of residence: NDS
Version: Office 2010  
Hello Take a look ... I know that you actually only wanted the relevant data on the axis, but for that your data source would have to be designed completely different. _________________ Greeting zero

You can freely change the rank in the profile
Posted:
March 18, 2013, 5:57 pm
First name:
Version: Office 2010  
It is not the goal yet, but a good step in the right direction! Thanks for your work. I'll check it out again tomorrow. greeting Michael 
You can freely change the rank in the profile
Posted:
March 19, 2013, 3:04 pm
First name:
Version: Office 2010  
I have still one question ! Where did you get the value of 0.0416666 for the hourly interval? And what would be the value for a halfhour interval? Thanks and regards 
Formulas, diagrams and a bit of VBA
Posted:
March 19, 2013, 3:25 pm
Call name: Dennis
Place of residence: NDS
Version: Office 2010  
Hello Just write 1:00 or 0:30 in a cell and then format it as a number. _________________ Greeting zero 
You can freely change the rank in the profile
Posted:
March 19, 2013, 4:29 pm
First name:
Version: Office 2010  
I've played around a little again and came to the result in the appendix. Now he shows me faults 1 and 2 already times. But no more after fault 3 and 4. Can someone take a look over there? Where is the upload assistant, please? The help file upload doesn't get me any further because the attachment control center is missing! Thanks and regards 
Formulas, diagrams and a bit of VBA
Posted:
March 19, 2013, 4:35 pm
Call name: Dennis
Place of residence: NDS
Version: Office 2010  
Hello from the help file upload 1. Log in to the User_Upload_Medium group. _________________ Greeting zero 
You can freely change the rank in the profile
Posted:
March 21, 2013, 9:43 am
First name:
Version: Office 2010  
So I was now also activated for the file upload. As mentioned above: Now he shows me faults 1 and 2 already times. But no more after fault 3 and 4. Thanks and regards

Related topicsForum / Topics reply author Calls last contributionExcel formulas: conditional formatting can also be used on diagrams ??0InesSbg240605 Feb 2009, 4:09 pm
InesSbg2 Excel formulas: diagram with variable values6bermudez1210Nov 16, 2008, 11:30 pm
bermudez Excel formulas: Transfer the trend line formula of a diagram to a table5guest373308 Apr 2008, 3:22 pm
ardom Excel formulas: maximum number of data series per diagram4guest6419March 24, 2008, 10:40 pm
guest Excel formulas: help with the working time chart2albert584763Feb 24, 2008, 1:34 pm
guest Excel formulas: several data series in one chart0sportis132708 Feb 2008, 11:38 am
sportis Excel formulas: Automatic table expansion / dynamic diagram0arabraB263306 Feb 2008, 12:37
arabraB Excel formulas: dynamic chart2fly_away1135Jan 17, 2008, 9:29 pm
fly_away Excel formulas: formulas in chart?5Change1833Jan 16, 2008, 10:46 pm
Change Excel formulas: Inquiry: Employee monthly utilization diagram2MarioPT4566Jul 13, 2007, 9:41 pm
guest Excel formulas: chart0anger480Apr 19, 2007, 7:29 am
anger Excel formulas: dynamic table with diagram3guest1313Feb 25, 2007, 1:46 pm
E4M
InesSbg2 Excel formulas: diagram with variable values6bermudez1210Nov 16, 2008, 11:30 pm
bermudez Excel formulas: Transfer the trend line formula of a diagram to a table5guest373308 Apr 2008, 3:22 pm
ardom Excel formulas: maximum number of data series per diagram4guest6419March 24, 2008, 10:40 pm
guest Excel formulas: help with the working time chart2albert584763Feb 24, 2008, 1:34 pm
guest Excel formulas: several data series in one chart0sportis132708 Feb 2008, 11:38 am
sportis Excel formulas: Automatic table expansion / dynamic diagram0arabraB263306 Feb 2008, 12:37
arabraB Excel formulas: dynamic chart2fly_away1135Jan 17, 2008, 9:29 pm
fly_away Excel formulas: formulas in chart?5Change1833Jan 16, 2008, 10:46 pm
Change Excel formulas: Inquiry: Employee monthly utilization diagram2MarioPT4566Jul 13, 2007, 9:41 pm
guest Excel formulas: chart0anger480Apr 19, 2007, 7:29 am
anger Excel formulas: dynamic table with diagram3guest1313Feb 25, 2007, 1:46 pm
E4M
 How does gravity help with interplanetary satellites
 Why are Beyonce fans called Beyhive
 When should you treat a brown stain?
 Fake mobile camera companies with megapixel numbers
 How do I teach JavaScript online
 What is the treatment for Epiphora
 What do MRAs think of MGTOW
 What is a province synonym
 Why can't there be perpetual motion machines
 If bran is strong m will sacrifice himself
 How were headphones made
 When do lies benefit society?
 How is THC removed from CBD plants
 Why is my iPhone 6 charging slowly?
 What is a Citizenship Act 1
 Who invented mechanical energy
 What's the salary of Cricbuzz commentators
 Faith is an unsatisfactory concept
 What other names mean psychic
 Who makes Pakistan's foreign policy
 Is religion gifted by God or created by humans
 What if the Japanese islands never existed?
 What is aspartame made of
 Opportunities to promote brands