Time And Graph Preferences

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


ADVERTISEMENT

Make A Graph That Will Graph Against Time

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

Line Graph: (line Graph To Display An Amount Over Time)

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

Menu Bar Preferences..

Jul 30, 2009

I have created an item on the menu bar (called “Personal Macros”) to run a number of macros in a spreadsheet. Under the menu bar I am trying to create two ControlPopups (called “Grouping Preference 01” and “Grouping Preference 02”).

For each ControlPopup, I am trying to add Control Buttons to the right, which will run the macros assigned. For Grouping Preference 01, add Macro 1 and Macro 2 as control buttons. For Grouping Preference 01, add Macro 3 and Macro 4 as control buttons

I have code to create the new menu, add popups, and add control buttons but it is not working as expected. The current code is placing all four macro control buttons under the same ControlPopup. I want the control buttons for macros 1 & 2 under one popup and the control buttons for macros 3 & 4 under another popup.

View 2 Replies View Related

Print Preferences

Aug 7, 2007

When I print, can I have the [VBA?] preferences not to print D16:E16?

View 9 Replies View Related

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 View Related

Time Model Graph

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

Universal Viewing Preferences....

Sep 24, 2009

Is there a way so that on his computer he can tell Excel that each sheet to be viewed should have a standard/automatic view set to 100% or another percentage?

View 3 Replies View Related

Graph Composition Of Group Over Time?

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

How To Save The Layout And Other Preferences / Settings

Feb 25, 2009

Is there way we can save the layout and other preferences / settings (and there are a huge no of those in excel) to a file or can we copy out the file where excel saves this data ? Probably a User Interface folder or something ? This is so that when i do a fresh reinstall of MS OFFICE i dont want to spend so much time resetting the customizations ive created over time.

View 5 Replies View Related

Preferences Keep Defaulting To Manual Calculation

Dec 22, 2009

I am on a Mac running OS 10.4.11. Whenever I launch Excel 2008, I have to go to Preferences and set Calculation to automatic.

Then Excel calculates automatically until the next time I launch the program. Then I find it has defaulted back to manual.

View 3 Replies View Related

Retrieve External Data With The Preferences

Sep 30, 2008

basically all it does is retrieves external data with the preferences that I set... what I want to do is change the code so that instead taking the same URL address it refers back to a specific cell in a workbook for the address.

View 3 Replies View Related

Chart A Graph Of Jobs Over A Period Of Time

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

Counting Number Of Days Over A Time Scale - Graph

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

Count / Calculate And Graph Sales Of Unique Items Over Time?

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

VBA Needed To Make Separate XY Scatter Graph For Each Group At A Time And Must Be Unique

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

Auto Copying Entered Preferences From A Master Sheet To Multiple Worksheets

Jun 26, 2009

I have a master page with A1 containing the names of staff members and then 5 columns indicating preference1 .... preference5. Each preference column will have one 4 digit site code i.e. 8156 entered. I will have 64 worksheets matching all potential 4 digit site codes that could be entered in the preferences columns.

SAMPLE - one staff member entering 5 site codes (A1 to A6)

Billy Bloggs - 8124 - 8456 - 8456 - 8123 - 8882

What I am looking for is a way to autocopy the persons name to the appropriate worksheet and into the correct preference column as I enter the 4 digit code against the staff members name on the master sheet.

View 3 Replies View Related

Creating Line Graph - Gradual Rises And Falls In Profit Over A Period Of Time

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

Make A Scatter Graph That Will Graph The Attached?

Mar 21, 2014

I would like to make a scatter graph that will graph the attached. The score would be on the Y axis and the birth date would be on the X axis. This is simple to do by itself but what I would like to do in addition to this is to have the top 25% of the scores a single color, the middle 50% of the scores a second color and then the bottom 25% of the scores to be a third color. And if it is possible to have the ID visible when you move your cursor over a given dot in the graph. Currently when I make a scatter graph the X,Y coordinates show when I hoover the cursor over a dot.

View 7 Replies View Related

Display End Time Automatically Upon Entering Start Time And Time Usage

Dec 19, 2008

I have a worksheet which contains START TIME in column A, then TIME USAGE in column B and END TIME in column C. User enters start time, followed by the number of time usage in minutes, how could i possibly display the end time automatically in this scenario? how do you add the entered time usage to the start time to display the end time? Say if I enter 1:00 AM at start time and 00:15 minutes on time usage, how can 1:15 AM be displayed on the end time automatically?

View 2 Replies View Related

Calculate Time Between Start Time And End Time?

Feb 7, 2014

the vendor has a 21 hr working window; start from 7am and goes until 4am; Mon to Fri.

Here is a scenario:
- i request for a product information from a vendor on 3-Feb-14 8:00am (Monday)
- he replies with all of the product info on 6-Feb-14 12:00pm (Thursday)

can you find the time in above scenario consideration the working window?

Here is another scenario:
- i request for a product information from a vendor on 6-Feb-14 8:00am (Thursday)
- he replies with all of the product info on 11-Feb-14 12:00pm (Tuesday)
- Sat & Sun are days off but keep in mind that my Friday shift ends on sat at 4am so the networdays formula wont work.

View 2 Replies View Related

X-Y Graph

Nov 11, 2009

I have a X-Y graph with 602 data points. My x scale is a counter from 1 to 602 and the Y is a decreasing set of numbers. When I hover my mouse over the points on the graph (I zoomed the graph) My first 3 points are all labeled as Point "1". At the end of my graph, my last 3 points are labeled 599,601,602, it skips 600.

I am using Excel 2007. Has anybody seen this before?

View 9 Replies View Related

Getting Decimals To Appear On Graph?

Jul 17, 2014

I am creating a graph with a wide range of values (0.06 - 300). The smaller values are barely visible on my column graph. I have tried all of the tricks I know. Any way to get the smaller values to show up instead of just hovering towards the bottom of the graph?

View 9 Replies View Related

Set Up Graph With Dates

Dec 27, 2013

I need to set up a graph (smooth line chart possibly) with an (x axis) that are not regular intervals. I've attached an example.

the amounts would be (y axis) and the corresponding dates (x axis).

That would be great to start with. Then I have one of these sheets for each month, can there be a continuous graph made using each month or does it need to be individual graphs.

Davyccexamp1.xls

View 4 Replies View Related

How To Get Quadrant Graph

Jul 22, 2014

I want to plot a quadrant graph as in the attachment, but I can't find them. how to plot them.

View 2 Replies View Related

Put The Annotation On The Graph

Feb 27, 2007

I need to create a graph using the data in the following format:
Item X Y
A: 10 100
B: 20 200
C: 30 300
D: 40 400
E: 50 500
etc.
I need to annotate points with A,B,C etc in the scatter plot so that the same can be quickly identified in the graph.

View 9 Replies View Related

Scattered Graph ..

Feb 16, 2009

I have three colums of data.

First represet company , second colum represent data1 ( x- axis) and third represet data2 ( y-axis).

I want to plot x-y graph with the company name

Eg.
McDon | 10 | 20

In the above case i want to show a round circle or dot which will be 10 right on x axis and 20 up on y axis and near the dot i want to show McDon as company name.

See that attachement... Graph is coming well.. but i am not able to add the company name to the dots.. or pot of x and y intersection

View 6 Replies View Related

Grouping In A Graph

Jun 16, 2009

I would like to create a graph where the numbers are grouped in such a way as all numbers between 0 and -1 are shown in one column, all numbers between -1.1 and -2 are shown in the next column, all numbers between -2.1 and 3 are shown in another column etc

The numbers are shown below

11/03/09
-2.5
-3.8
-3.9
-4
-4.1
-4.5
-4.6
-4.9
-5.2
-5.4
-5.4
-5.5.......

View 2 Replies View Related

Graph Plotting...?

Jul 12, 2009

I use spectrometer in my reesearch. The datas are in (a, b) format in single cell. Is it possible to seperate a and b seperately? like a in seperate cell and b in seperate cell?

View 4 Replies View Related

One Graph Three Variable

Feb 4, 2010

I want to carry out a survey in Sept, Oct and Nov. I will asking 1000 random people in each survey what is their personal favourite--- iPhone, Nexus or Blackberry. Counts of each phone type is then divided into male and female.

Now we have three variables: gender, phone type and month. Is there any way I can present 3 variables on X, Y & Z axes and the value at their intersection as bubble size (or colour gradient)? Theoretically it's possible but I can't find a way to do it in excel. Or anyone knows any software that can get the job done?

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved