Creating A Graph Over Time
Feb 13, 2009
Hi i have alot of values that i would like to display in a graph over time.
The problem is, is that there are many different times (irregular intervals) that the value is recorded during each day.
whenever i create a graph and choose the x-axis format as the date i get a spike at each day, which is no good!
value Date Date Time
0 22/12/2008 12:33:35 22/12/2008 12:33:35
0 22/12/2008 20:53:25 20:53:25
9 23/12/2008 00:48:48 23/12/2008 00:48:48 ....
View 9 Replies
ADVERTISEMENT
May 27, 2014
I am trying to make a line graph showing the gradual rises and falls in profit over a period of time, when I use the data and click line graph normally, it will plot each bit of data individually rather than gradually, for example;
13-Sep-13GBP 1,107.57
18-Sep-13GBP 6,432.74
21-Sep-13-GBP 477.71
22-Sep-13GBP 19,664.65
23-Sep-13GBP 1,604.88
If I tried to plot the above data, the graph will not show a gradual rise but instead will show a value of £1604.88 on the 23rd of September when instead I would want the chart line to be at £29,287.55 (The total).
View 5 Replies
View Related
Jun 11, 2006
How can i make a graph that will graph against time? lets say i have a bank balance like this:
1/2/2000 $500
1/3/2000 $600
3/12/2000 $400
there may be more than one entry on any one given day, or there may not be an entry for 2 weeks. How can i graph the running balance in a way that it will show the timeline just as a calendar year(or however long i selected) and the points are plotting according to their date, not just equally spaced out.
View 2 Replies
View Related
Feb 10, 2013
I want to create a graph as showed below.
Actual graph will contain a larger/longer X-axis (40 instead of 6 readings), but no more than 2 rows af data (A and B), of which one has a seqenced number af data (row B).
Row B alo has got singular points of data superimposed over the cylinders.
I have got all the numbers ready, but I don't know whether or not it is even possible to create a graph like this.
The cylinders have values up to 45.000 (accumulated in row B), the points (black dots) go from 2 to 6.
If so, I'm having trouble selecting the correct template out of the excel's standard list of graphs.
View 9 Replies
View Related
Jul 9, 2006
I have implemented a function in VBA which calculates certain values, called 'IndexSim.' These values are not required to be outputted into the spreadsheet, however I would like to create a simple line graph plot of these values against 1,2,....etc however many values are chosen to be created. The code is as follows:
'Create storage for FTSE100 and binary payoff simulations.
Redim IndexSim(1 To SampleSz) As Double
Redim Payoff(1 To SampleSz) As Double
'Do the simulations.
For Cnt = 1 To SampleSz
IndexSim(Cnt) = gBmProcess(Kt, r, q, Vol, TMat - TNow)
If IndexSim(Cnt) >= IndexBetValue Then
Payoff(Cnt) = Range("D18").Value
Else
Payoff(Cnt) = Range("D19").Value
End If
Next Cnt
how I can create a line graph for the 'IndexSim' values, which will update everytime the macro button is clicked.
View 4 Replies
View Related
Feb 13, 2012
We have a bunch of 8 digit Purchase Orders (POs) with end dates. We want to show all ten different PO's on a Line graph on the left with the end date at the bottom. Our issue seems to be that:
1. The graph doesn't show the exact PO #, but does a range. We need each PO number listed. How do we get the graph so show each individual PO on the left?
View 2 Replies
View Related
Aug 11, 2008
I want to add a button to a worksheet to allow a graph to be exported as an image. This seems to be a fairly common request, I have read some of the posts but cant get it to work. I am using Excel 2003 as that is all we have...
So, I have a simple button on 'sheet1' containing :
Sub CommandButton1_Click()
Worksheets("Sheet1").ChartObjects("Chart 1").Chart.Export Filename:="h: est.jpg", FilterName:="jpg"
End Sub
.. but it doesn't work. I get the error :
Run-time error '1004':
Application-defined or object-defined error
View 9 Replies
View Related
Dec 17, 2008
I have a spreadsheet that I'm trying to make a graph that shows the amount of letters mailed in a certain month.
The first line has 01/24/2008 as date received and 01/28/08 as date mailed. I'm trying to make a graph that shows the amount of letters received and mailed in each month. I know there are probably numerous ways to do this but I'm looking for the most effiecent and I would like to be able to update the same spreadsheet and have the graph update as I add information.
View 9 Replies
View Related
Oct 21, 2009
I am trying to create a line graph to show the trends (up or down) of I-Fund vs Gold. The trouble I am having is how to set the axis. The date one is an easy one, but the gold range is more or less 800-1000, and the I-Fund is 13-18. How can I have these both on the same graph to compare? I am attaching an Excel sheet as a reference. Obviously I need to delete the empty IFund cells.
View 2 Replies
View Related
Nov 12, 2006
i have a set of data range from B1 to K10 (10 cells all together).
and i created a graph by selecting from B1 - K10.
what i want is, if i key in range from 1-10 in A1, the graph will change based on the number i keyed in (from 1-10).
if i keyed in 5 in A1, the graph will auto select B1 to F1 and show data from B1 toF1
then if i select 6 in A1, the graph will auto select B1 to G1 and show data from B1 to G1
View 9 Replies
View Related
Dec 30, 2008
I want to use a line graph to display an amount over time - that's the easy part. On the other hand, I would like to have to group the lines based on a value.
A short example:
Imagine you own 3 different stores and you're selling oranges. So your table looks like this:
http://img179.imageshack.us/my.php?image=orangeshm4.jpg
Now I'd like to have one graph (3 different graphs won't work as the rows increase -I need to select the whole column as data source):
Date on the x axis,
Oranges sold on the y axis,
and one line per store (e.g. a green one for store A, a red one for B and a blue one of C, doesn't matter).
View 2 Replies
View Related
Jul 24, 2014
What I have done is entered code to auto generate the date in column O whenever data is entered or altered in column A. Here is that code:
VB:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A:A")) Is Nothing Then _
Target.Offset(0, 14).Value = Now
End If
End Sub
What I am trying to do now, is create a column that will take the information from O and do a sort of COUNTIF function that will count how many items of data were entered on a certain date by the day. For a clearer example, I want it to tell me how many items were entered/altered on 7/23. But I also want it to continuously calculate it for each date after that. Preferably automatically, but if a macro is needed I can create an update button.
Once it can achieve that I would like to create a dynamic graph that will automatically (or via macro button) update to show the last 5 days. It should display the date and how many items were entered that day.
I am using Office 2007.
View 1 Replies
View Related
Mar 2, 2014
I'd like to create a simple graph exactly like the one on the picture, but for the life of mehow to do this on Excel 2010.This is the data I have:
Seperation First target Second target
0 59.00% 0.00%
2 64.28% 40.62%
4 62.68% 48.99%
6 60.81% 65.83%
8 61.82% 70.21%
View 6 Replies
View Related
Jan 24, 2014
I am trying to do the following
Unit Percentage Score Unit 1 Percent ScoreJohny SmithBetty Donovan
Unit 1 Operations & Algebraic Thinking2100.00%50.00%
Unit 1 Measurement & Data3100.00%66.67%
Unit 1 Geometry0#DIV/0!#DIV/0!
Unit 1 Number & Operations Base Ten16100.00%93.75%
1-I would like to create a type of link or button that would exist in the cell "Johny Smith" so that when a teacher clicks on that name excel would generate a graph or pie chart for the specific data associated with Johny and when a teacher clicks on Betty a different graph would pop up. I know teachers can just highlight the data and insert charts, but many of them don't know how to do that. I have been asked to make the process a one click function.
View 1 Replies
View Related
Jul 1, 2007
I have a sheet with a table of peoples hours they are doing during the week each day. I want the hours to be put into a model shading the appropriate times to show when people will be in. I have attached a sample sheet of what i want it to do which i have had to do my self. Sheet 1 has table in and sheet 2 has the model i want to be automatically filled in once ihave entered all my data in the original table.
View 11 Replies
View Related
Jun 18, 2008
I'm having a couple of Excel problems.
1. I have a SQL query that returns a time span. Is there any way Excel can convert, for example, 51.9451388888889 into dd.hh:mi format that still allows me to manipulate the data as time so that I can add times together and compare times. So I would like the number above to be formatted to look like this '51.22:41' and still be able to work with it as if it was just a regular time.
2. I want to make a graph from this data I have (the data in the question above). The data has this output format:
A ----B-----C
Date-time ( dd.mm.yyyy hh24:mi)----- Time span -------- Reason
I would like to make a graph that displays for each month the 5 highest Timespans on the y-axis and their reasons on the x-axis.
View 9 Replies
View Related
May 30, 2012
I want to graph the composition of a group over time. I want to create an area graph, where you can see what kinds of things were in the group at any given year . There are, let's say,three categories of things: A, B, and C - and I have the purchase and sale date for each.
View 2 Replies
View Related
Jun 17, 2007
I have an Access database, with a table of jobs processed.
One column for Job ID (Unique), Date it was processed, By Who it was processed and Comments ascoiated.
I need to chart a graph of Jobs over a period of time. How many jobs done per date. In excel preferebly, I have programs like Database Plus for excel. And I am familiar with VBA. I can't figure out how to uniquely sort how many jobs for each date. As there are numerous job entries for on the same dates. I think it can be done with an SQL query or sorting it with VBA somehow. Any help will be greatly appreciated. Or can anyone suggest an application designed for charting with Access databases in Excel?
View 6 Replies
View Related
Feb 8, 2007
I have a time card that is split into sections so there are a lot of SUM formulas. However, I need to include a space for breaks - 10 min.
How do I make everything convert comfortably?
Ex. 5 hours allotted to person A. 5 hours to person B. 1 hour 40 allotted to tasks. And 20 min per day for breaks.
Is there a way to format the cell so that it displays hours and minutes
1:35 = 1hr35min ??
All the formats available show it as time. I need it as a quantity of time rather than time of day so that the formulas will add correctly.
View 9 Replies
View Related
Oct 6, 2012
I have got a project that has several hundred starts and finishes. I want to count them over time to use as an indication of progress. ( I want to show this graphically)
I have got the graph working but it is pretty long handed.
I have tried using a pviot table and picvot graph which almost does it but has a few problems (if there is no data in a month then it wont create an entry for the month, and the cumulative over time is not quite working).
Both examples are in the attached file : Progress Curve ozgrid1.xlsx
View 6 Replies
View Related
Nov 24, 2013
My company has a catalog of ~6000 unique SKUs that we sell online. Currently we do not have a way to quickly determine how much a given item has sold month over month, and the rate of that change.
I have an excel workbook full of our last year's worth of sales data. I have organized it by placing each month of data in its own worksheet. I would like to be able to create a search box that will allow us to enter in a product ID, and have excel then create a graph with each month's of sales for that particular item. Is that clear?
View 11 Replies
View Related
Aug 19, 2014
I have 5 different groups for that i have to make XY scatter graphs and my data looks like this
XY
125
13
156
145
134
234
248
260
2102
2105
3125
3148
3198
3298
3245
4386
4369
4234
4465
4898
5902
5907
5345
5234
5209
now i want to make 5 different graphs one per each group. Now i am making them manually in excel but it is taking lot of time to format each graphs to get unique graphs. I am attching sample file and graph for better understanding.
View 3 Replies
View Related
Dec 4, 2013
I am trying to create a formula that subtracts 1 hour if the value of cell E3 equals 11:00 PM.
This is what I've tried:
=SUM(E3-D3), IF(D3=11:00 PM, -1:00)
View 9 Replies
View Related
Aug 4, 2006
I need the users to be able to enter the time using either a . or a colon :,
So: 13:30 would give 13:30 and 13.30 would give 13:30. They have end up in time format too since I will be performing calculations on them. When that decimal place is entered I would like it to be turned into a dot
View 3 Replies
View Related
Jan 14, 2007
code that creates hyperlinks by the column or row. I Have a spreadsheet with some code which archives data into a summary sheet and creates a backup sheet of the detail. This all works really well. In the summary sheet, I have a column that is named with the name of the new worksheet.
What I want to do is to be able to create a hyperlink from this name in the column to the new, backed up worksheet. I do not want to create a list of hyper links, I only want to create on link at a time, each time I run the code.
View 3 Replies
View Related
Oct 2, 2007
Create a cell with running time in Hours, Minutes, and seconds, in 12:00:00 AM format.
View 13 Replies
View Related
Jul 29, 2008
I would like to add something to my workbook which, when called, gives you current time in Tokyo, Australia, USA, London, Europe (for example).
I am trying to work out what would be best.
Would it be possible to create this on the Status bar?
Alternatively, i guess a Userform shown as modeless (but i am not sure if the controls holding the times will update.
View 9 Replies
View Related
Aug 6, 2014
I seem to struggle with excel formulas when time is involved. I am trying to create a spreadsheet that reviews outcome measures (walking tests in this case) to outline firstly if someone has improved or not (Outcome in the blue columns) which seems to be working alright. This takes into account the 2 aspects of time taken to complete the test and the walking aid required.
What I would now like to be able to do is compare each individuals 'After' score with a normal range for that test. I have put a list below the table of the ranges I am looking for. I have tried to put time formats into a long IF formula to try and get the ranges covered for the TUAG test, but doesn't seem to be working.
The 10 metre walk test is a little trickier as this is looking at change in velocity between the before and after scores. I think I need to be able to work out the velocity for each test and then do a comparison, but again bit stuck with the time formatting.
View 2 Replies
View Related
Jun 17, 2014
I have a piece of code that runs and creates an output Excel sheet that currently has the run date as a suffix for the automatically generated file name. However, I now sometimes have to run this report multiple times in one day, which currently means overwriting the previously run spreadsheet (whereas I would like to keep both versions of the ruin output).
Is there a way that I can create some kind of counter for the number of times the report is run and add that as a suffix for the file name? At the moment the only way I can think to do this is to set up code that looks at the file name containing the date field and adds 1 to every number that is added as a suffix, but this doesn't seem very efficient...
View 2 Replies
View Related
Jun 11, 2008
I am creating 10 pivot tables for data in one worksheet and putting them in a separate work sheet. i used the macro recorder but the cod eit worte stop at this line ...
View 9 Replies
View Related
