I can make either a supply or a demand graph without problems, however no matter where I place the vaules, ie wage first, demand, then supply or demand, wage, supply, the graph will not work or look right. The wage must be on the left had side so that the graph complies with standard Supply and Demand. I also need to be abble to make another graph showing what happens with a wage cap.
I can do it on graph paper, put I can not find a way to do it using Office 2007 Word and inserting a graph option and using Excel.
I am looking for a template where I can have the Gap between Demand and Supply of Resources. This is to plan taking up new opportunities or not based on the supply.
I have a spreadsheet which uses MS Query to import data from our MRP System. This Spreadsheet has all new orders and qtys required per sales order etc. Each Part number may have several sales orders and different qtys for each. I am looking for help to write a fomula which looks the required qty`s for each sales order & part and check another sheet which has all the avaliable stock to sell on it and populate a column next to the qty req`d with what if anything is available. Both the orders sheet and the stock sheet are MS Queries which refresh at a given interval so cells may change position.
Cutdown Example of Orders Sheet.
Sales Order No. ¦ Part ¦ Qty Req`d ¦ -------------------------------------- 1234 ¦ Apple ¦ 12 ¦ 6777 ¦ Apple ¦ 16 ¦ 7989 ¦ Pear ¦ 4 ¦
cutdown Example of Stock Sheet.
Part ¦Qty in Stock ¦ ---------------------- Apple ¦ 12 ¦ Pear ¦ 3 ¦
Now the fomula should bring back the following
Sales Order No. ¦ Part ¦ Qty Req`d ¦ Qty Avaliable ¦ ---------------------------------------------------- 1234 ¦ Apple ¦ 12 ¦ 12 ¦ 6777 ¦ Apple ¦ 16 ¦ 0 ¦ 7989 ¦ Pear ¦ 4 ¦ 3 ¦
Once you have created the supply and demand numbers and have put them in a graph or on a chart, how do you find the equilibrium point? Also, how do you show the equilibrium point on a chart.
For an economics assignment I would like to graph price elasticity with price on the 'y' axis and units on 'x'. I have not found a way to do this in Excel, can someone assist?
I have never coded for graphs using VBA where when I run the macro it changes to the 20 most recent data values collected. If column "A" is going to house my y-values and column "N" is going to house my x-values, what would be the coding to change the graphs data range?
My Idea: I am thinking to get the 20 most recent values I could use a row variable that would equal
Code: Cells(Rows.Count, "A").End(xlUp).Row
This would find the last data point entered. I just don't know the proper syntax to manipulate a graph.
I have a pivot chart which has one Axis field (Cell Ref2) and one Sum of Values field (which is a table series of percentages calculated from formulas)
I see the graph like I'd expect, but I'm struggling to get it to show percentages rather than basic integer units on the y-axis? Usually I would imagine to just right click on the y-axis : Format Axis, and expect to see something to change the display units, but it is only for hundredths thousands etc rather than a percentage ? The units themselves in the table for that value series are in percentages so I don't see why it isnt showing the percentage units in the first place.
I need to make a spreadsheet on excel which shows the production schedule of a product over 4 days.
Then I need to make a supply ordering sheet which shows how much supplies are needed to do the above task and how much each item in the supply list will cost and when the items would need to be ordered.
I receive the following error whenever I try to run a macro in Excel: "System Error &H80040111 (-2147221231). classFactory cannot supply requested class." This is immediately followed by "Out of memory"
I was eventually able to stop the error from occurring by removing all forms containing a listview control in my macro file.
I have tried repairing my Office installation, uninstalling and reinstalling Office, and reregistering MSCOMCT2.OCX but nothing seems to work.
I am using =randbetween(1,100). however everytime i enter a new number elsewhere on the sheet, a new ndom number is made. Could you make a button (or something) that, when pressed, creates a random number in a certain cell?
I am currently using the following formula to calculate the average weekly demand of a product:
=SUM($G8:$CF8)/COUNTIF($G8:$CF8,">=0"))
It works fine, but sometimes the data I'm analysing doesn't span the full horizon (78 weeks). What I therefore want, is for the COUNTIF part to recognise the last populated Cell in the array, and to use the length of the array up to that point to calculate the average. Put another way, if I only have 52 weeks of data (the last populated Cell is $BF8), I want the COUNTIF to calculate based on 52 weeks and not 78 weeks.
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.
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.
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).
This is going to sound very simply to most here I'm sure. I have a need for a simple ledger, credit, debit, balance. I will only have maybe 12 accounts and want to keep track of hand written invoices and payments.
Here's what I would like: I return to my office, click on a tab for an account, enter the date and amount of an invoice in a debit column for that account. When payment is made, enter the amount received in the credit column. Having a running total in the balance column. A monthly statement option would be nice, but not necessary.
I have searched for templates of general ledgers and get results with budgets, projects . . . just too complex for my needs now.
I am trying to do a nested IF statement in which if Cell A has a number, display it. If Cell A = "", look in Cell B. If Cell B has a number, display it but if its "", then display Cell C.
I have the IF statement working for the first two pieces but don't know how to incorporate a third statement: =IF(A="",B,A)
This works - how do I get it to check Cell B and show Cell C if B is empty?
way to count cells in a spreadsheet (not values in the cells but just the cells themselves). So I have a whole bunch of cells, some are red, some are blue, some are green based on the info i have to keep track of.
so can i write some COUNTIF for red cells green cells, etc
I have a VBA userform with various textbox fields like 'Name' and 'Address' and 'Amount' I would like an input box to pop up that asks the user to 're-enter for verification' So that they have to type the same thing twice, to protect against typos
How do I code it so the program compares the inputbox to the textbox and passes only if they are identical?
(or even, using two inputboxes instead if that would be easier)
What I would like to do is to insert the text "Agent" into the empty cell A# immediately above the block of names if "Agent" isn't already there. I'm having trouble with the syntax... The cell A# won't always be the same as the position of the block of names varies. In this case it's A9.
I'm trying to write a basic macro which will increase the value in a cell by 1 when I click on the button I've made. I've searched for hours on the Internet, including this site, and found several websites which give a formula needed but none of them work, I always get an "Object variable not set" error or something about sub-functions which I can't recreate so I can't give the full error message. Sorry.
Based on what I've seen on the Internet, I currently have:
Using Excel 2003. I have a very basic SUM formula I am using to show how many forms are still in-house. Pretty simple.
Column D is how many came in. Column F is how many were completed. Column E is what is left.
To get the daily count I take the previous day's Column E, add to today's Column D and subtract today's Column F.
=(E2+D3-F3) Puts the results in E3.
This formula is copied on down the worksheet which results in: =(E3+D4-F4), with the results in E4. And so on down Column E.
The problem is that if there is no data entered in Column D or F, the results from E are carried (copied?) as far down as the forumla. i.e., if today's column E results in 4, then that is displayed for as far down as I have copied the formula. What I'd like to do is set the formula so that if there is no data in columns E or F, then there is nothing displayed in Column E.
Here is my simple Private Sub that I can't get to work,
Private Sub Worksheet_Change(ByVal Target As Range) Dim c As Range For Each c In Target
[Code]....
I have a checkbox control that changes the value to "True" or "False" in column 4. Here lies the issue, if I use the check box control to change the value, the private sub does not work. If i type the value of "True" or "False" where the check box control stores its value, the private sub works. I would like to see if there is way to get the private sub to work by simply clicking on the check box control only.
How to do simple table lookup. I have a table showing #of colors being used for screen printing down one side and qty of shirts ordered going across the top. I would like a formula that when I enter the # of colors and the quantity of shirts it will return the correct price.
