Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
ebook!
Our Top 15 Excel Tutorials
Instant Access!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:


Advertisements


Free Excel Forum

How Do You Graph A Ppf (production Possibilities Frontier) Chart .

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More




View Answers     

Similar Excel Video Tutorials

Helpful Excel Macros

Create a Column Chart with a Macro in Excel
- This macro adds a column chart to Excel. This is an easy to use macro that allows you to quickly chart and graph a rang
Get Values from a Chart
- This macro will pull the values from a chart in excel and list those values on another spreadsheet. This will get the s
Create a Line Chart with a Macro in Excel
- Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs from
Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts
- Delete all chart sheets and tabs in Excel using this macro. This will only delete the charts and graphs that are in the
Print all Embedded Charts in the Entire Workbook
- This macro will print every embedded chart in the active workbook. If you have an embedded chart in any worksheet within

Similar Topics







te: Sun, 30 Jan 2005 22:21:59 -0500
From: Jon Peltier <jonREMOVExlmvp@peltierCAPStech.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Subject: How do you graph a PPF (Production Possibilities Frontier) chart



Hello. I have Graphing Woes. Basically, I don't want to graph zeros. Let
us say that the user is inputing two kinds of production dollars every day.
Production 1 and Production 2 graph fine individually, i.e., the graph stops
where the numbers stop, because they are blank cells until the user inputs
numbers. But the graph of TOTAL (Type 1&Type 2) graphs all the zeros until
the end of the column. I realize this is because TOTAL has zeros stored in
it until the formula receives other number, but I've tried putting in ""
instead of zeros and I've tried Chart Options -Don't Plot Zeros. Neither
works. How do I keep the total chart looking like the individual charts?

Thanks, Arlen



Hi there,

I'm glad i stumbled across this forum as I haven't been able to figure something out. I'm very new to excel, by which I mean i just started using it for the first time 3 days ago, but that hasn't stopped my work from giving me tons of things to do with the program. Anyways, i'm learning quickly but i;'m having difficulty figuring out how to make a graph which shows a workers production on the y axis and the quality on the x axis. However, instead of having two points on a standard xy scatter graph, I need a four quadrant graph that plots the worker (as a single marker on the graph) in one of the quadrants.

Basically i want any worker in the
upper right quadrant: to have high production and quality,
lower right quadrant: to have low production but high quality
lower left quadrant: to have both low production and quality
upper left quadrant: to have high production but low quality.


If anyone can shed some light on this you will make my workday much better.


I have created a Pareto graph using the 'Large' & 'VLookup' formula.
So the graph takes the 1st to the last in order (to plot which is the highest loss) but I have a problem that if 1 or more Totals are the same, then the graph shows the total as the same name.
See below:

TOTAL TOTAL DAMAGE 62 Bagger 1 136 Bagger 2 71 Bagger 3 48 Bagger 4 68 Others 41 Production

BAGGER TOTAL Bagger 2 136 Bagger 3 71 Others 68 Bagger 1 62 Bagger 4 48 Production 41

Now when the top sheet has gathered the data required it displays them in its top order and creates a graph.
As you can see the top is Bagger 2, Bagger 3 and so on till the bottom = Production.
This gives me all that I rerquire when teh figures are all different but as you will see below it does not match on the graph when some figures are the same.
TOTAL TOTAL DAMAGE 62 Bagger 1 136 Bagger 2 71 Bagger 3 71 Bagger 4 68 Others 41 Production

BAGGER TOTAL Bagger 2 136 Bagger 3 71 Bagger 3 71 Others 68 Bagger 1 62 Production 41



The graph now should show the top as:
Bagger 2, Bagger 3, Bagger 4 and so on.
But as you can see it shows, Bagger 2, Bagger3, Bagger 3 and so on.

How can I show all the areas if the area is the same on more than one,

Hope this makes sense.

Pugg


First let me describe what I am trying to do.

Have a "spread range" (ie. 200-325, 330-455, etc.)filled down in columns that I want to graph as a Max, Min, Mid type chart. I tried to use a =LEFT(, =RIGHT( formula to draw only the characters that I needed, however, when i did this my graph stopped reading the values. Any reason why this might happen? Or are there any possibilities that I am missing to make this easier?

I can only assume that excel cannot graph these formulas, but usually I am assed. Please help!

Thanks,
Rob


Hi there,

I have a sheet which contains apple production at different bases. I want to create a nice way to present the data to people who uses the sheet. I would like the data to be shown in such a way that the plan, actual and differences are shown in one graph and this one graph should update with different base's data when a different base is selected. Like in a pivot table for example.
I tried using a pivot chart and I could not get the data to show what I require. Can anyone suggest a way to do such a thing if so, how?

Cheers.


Hi there,

I have a sheet which contains apple production at different bases. I want to create a nice way to present the data to people who uses the sheet. I would like the data to be shown in such a way that the plan, actual and differences are shown in one graph and this one graph should update with different base's data when a different base is selected. Like in a pivot table for example.
I tried using a pivot chart and I could not get the data to show what I require. Can anyone suggest a way to do such a thing if so, how?

Cheers.


I am looking to do something like this:

Code:

rng.Offset(5,9) = "The chart to the left " & _
                "displays the plot of the efficient " & _
                "frontier in relation to the " & title & _
                " IPS asset targets as well as the current " & _
                "asset allocation of the portfolio.  The " & _
                "IPS Targets " & _

                If Targets(1, 1) < Targets(7, 1) Then
                
                "fall below the efficient frontier which suggests " & _
                "that the portfolio could capture incremental returns " & _
                "by adopting a more efficient strategy."
                
                Else
                
                "fall on the efficient frontier so the implication " & _
                "is that if the portfolio were rebalanced to the target " & _
                "allocation, it would be an efficient portfolio."
                
                End If





I am in a production plant and want to track defects.
We have 2 shifts so I am entering data for each shift and I'm using the fomula =if((A1+A2)>0,A1+A2,NA()). I am using that data to create a line graph for each day and, if the cells are empty, I don't plot that point on the graph. If we run no production, we leave them blank and it doesn't plot...just like I want it to. Here's the kicker. If we run that day and have no defects, I want to be able to put zero's in the main table (say A1 and A2) and plot that as a zero day. I'm racking my brain trying to figure out how to do it. :x
HELP!!!


A B C
Capacity Production Capacity Production Capacity Production
Rockwool 100,000 65,000 0 0 200,000 120,000
Glasswool 600,000 320,000 1,000,000 970,000 2,500,000 2,400,000
Net earnings ($) 800,000 2,000,000 1,200,000
Market share Asia 5% 12% 1.2%
2007 Patents 8 23 190

I want to plot the above information of company A,B and C on one single chart in Excel. I tried many different formats but none are suitable to get al the information on one chart

Any Ideas guys?

Thanks


How do I change this formula to represent a range? I want cells C2:C18, but I ran out of arguments - can't add any more. If DRC or Production shows in the column, I want the word "Outstanding" if not, I want the word "Completed".

=IF(AND(C2"DRC",C2"Production",C3"DRC",C3"Production",C4"DRC",C4"Production",C5"DRC",C5"Production",C6"DRC",C6"Production",C7"DRC",C7"Production",C8"DRC",C8"Production",C9"DRC",C9"Production",C10"DRC",C10"Production",C11"DRC",C11"Production",C12"DRC",C12"Production",C13"DRC",C13"Production",C14"DRC",C14"Production",C15"DRC",C15"Production",C16"DRC",C16"Production"),"Completed","Outstanding")


I am extracting data from a different workbook that has production data that I want to see in a graph format.
I am sure I am going about it in a hard way.
The data that I am extracting are production target and actual production rates.
First I am extracting data from this individually into my workbook and then making a graph.
My first issue is...time.... It is so time consuming to change the value for each cell in a column manually. Is there a way for excel to autofill without having to manually change each cell formula.
Example of my command:
='[Daily Production (Mar2011).xls]1st'!$C$3

It is extracting the value from the Daily Production (Mar2011).xls workbook and then the next cell would be the same except I would need to change from 1st to 2nd, and then 3rd...so on....for the entire month, and then start over again for April.....and so on.
How can I change this without having to manually add the next day?

Also, my thought of extracting the data vs just the data into a graph is that I will want to eventually put in operator names so that I can somehow create a graph of individual production numbers and then at some time throw in downtime with reason codes.
I hope that this makes some sort of sense.
Thanks for looking!!

Ken
Sorry.....the excel vers that I am using at work is 2003 and the version at home that I play with is 2007.....


Hi.
My question, as exact as possible, although i'm not sure if this is even possible with VBA and excel.

But, it is very simple.


Instead of creating a chart with a TABLESET of data i create (the way everyone uses charts in excel),

I want to create a tableset of data from a CHART that i draw or modify...so the chart is the INPUT to a spreadsheet's data.


--further....

So, imagine opening an excel spreadsheet and seeing a monthly chart of production of widgets.
Then imagine clicking and dragging (ON THE CHART) next April's production up 20% from normal, and having this change the excel cell that refers to this point.

That is all.

The whole point of this is to use it as the front end to a complex spreadsheet, which will hopefully demonstrate how sensitive production and cost changes are to a business.


I'd like to have two of these charts in the same spreadsheet, which would feed data as inputs to my excel spreadsheet...one for costs, and the other for production.

-one other tidbit, the chart for "cost" should be represented as below the x axis (as a negative value). Production should be in individual units, and should of course be positive.


Please ask any questions for clarity. Thanks so much. I do hope you can help.



Tony Rogers


Hello,

I am trying to make a stacked bar graph that displays the coverage of items in my companies network. Each investment item is either covered or open, and either on target for budget, Above budget's target, or Under budget's target.

Thus I have a variety of possibilities for the data:

A) On Target -
B) Covered Under Target
C) Covered Above Target
D) Uncovered On Target
E) Uncovered Opportunity
F) Uncovered Risk

But since the data is grouped by covered and open I can only color the graph two separate colors, in two series, open and covered.

Is there a way to have multiple colors within the stacked bar graph based on the possible buckets it could fall in?

There is an attachment, I want the graph to look something like the red, gree, and yellow chart but right now I can only looking like the blue and yellow chart.

Please advise.

Thanks in advance.


How to plot efficient frontier from sets of data containing expected return,
average return, variance, standard deviation, covariance and correlation ?



Good morning.

I've done some searching through the forum and figured out how to create the Gantt chart I was looking for. I need to take it one step further, however. I want to be able to use the Gantt chart to view future year data. The chart currently displays 2008's final results. However, for certain items, the results will change by a certain percentage (not consistent across all items) in future years. For example, Item C may be in its third year for 2008, putting it at approximately 58% of its total potential production. I know that in its ninth year, 2014, it will be in full production. However, I also know that other items will be ending their production life within that time, creating gaps in overall production. I need to be able to see these gaps and plan ahead to fill them before they appear, so I need to be able to look at this Gantt chart and, given a table of production life for each item, be able to tell the Gantt chart I want to see results for 2014. Is this possible? Do I make sense?

Thanks.


I have a graph that displays daily production. There are 2 shifts a day, so the graph has 14 different data points. There is also a constant target line.

Since the graph gets updated twice per day (at the end of each shift) I want to add a column graph on the right hand side showing the total production compared to the target. For example, if I have a target of 5 every shift, the total target for the week is 5*14 = 70. And if so far I have produced 4 and 2 on the first day and 5 and 3 on the second day, the total produced is 4+2+5+3 = 14. I want to add a column graph on the right side on a secondary axis showing the two values (14 and 70).

Any idea how to do this?

I attached a picture of the graph I have now.

Thanks.


I have one worksheet with manning data and another with production data. I want to show how some procedural changes have affected the efficiency of the department by comparing production per man hour. Can I use a pivot chart to draw from two different worksheets to group manhours and production by date?


I have set up data validation before, however, my employer is asking for something I don't understand.

"Add a data validation to the department column allowing for new entries to the table to have only 1 of the departments that currently exist in the table."
Tomorrow, I will be adding a new employee to the chart.

Can someone please help? I have been working on this all night, need to go to bed, go to work and have this figured out....


Department Accounting Accounting Accounting Accounting Administration Administration Administration Engineering Engineering Engineering HR HR Maintenance Maintenance Production Production Production Production Production Production Production Production QA QA Shipping


I have set up data validation before, however, my employer is asking for something I don't understand. Excel 2007

"Add a data validation to the department column allowing for new entries to the table to have only 1 of the departments that currently exist in the table."
Tomorrow, I will be adding a new employee to the chart.



Department Accounting Accounting Accounting Accounting Administration Administration Administration Engineering Engineering Engineering HR HR Maintenance Maintenance Production Production Production Production Production Production Production Production QA QA Shipping

I'm wondering if it's possible to chart possibilities in two sets of data

fictional example:

Col A Rate:
1
2
3
4
5

Col B Base $ Value
1
2
3
4
5

So chart each row of A * each row B where a line in the chart starts with Ax*Bx and ends with Ax*By (in this example, 5 lines total)


I have used the code below to specifically colour certain points in certain ways, problem is it doesn't affect the legend which remains showing the default colour, any ideas

Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(1).Points(1).Interior.ColorIndex = 6
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(2).Points(1).Interior.ColorIndex = 36
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(3).Points(1).Interior.ColorIndex = 4
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(4).Points(1).Interior.ColorIndex = 35
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(5).Points(1).Interior.ColorIndex = 5
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(6).Points(1).Interior.ColorIndex = 34
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(7).Points(1).Interior.ColorIndex = 7
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(8).Points(1).Interior.ColorIndex = 38
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(10).Points(1).Interior.ColorIndex = 28
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(11).Points(1).Interior.ColorIndex = 33
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(1).Points(2).Interior.ColorIndex = 6
Sheets("Graph").ChartObjects("Chart 1").Chart.SeriesCollection(2).Points(2).Interior.ColorIndex = 36


Does anyone know how to set up the formula for the efficient frontier in excel? I am used to using SPSS and I am not all that familiar with excel.


Greetings All...
A department manager wants to post charts of factory work center production performance as Windows Screen Savers. That idea has some interesting possibilities. While any number of methods could be used to generate the charts, using Excel allows the possibility that anyone could design a chart for their own area.

Basically we want to have windows run excel, load, calculate, and display the chart whenever it wants to display the screen saver.

Has anyone ever done something like this, or have any ideas or suggestions?


Hello,

Using Excel 2007, and Windows 7.

Always something new, I guess; never had this before.

Have a chart as a Chart 1 tab on the bottom to which I add data once a week into Sheet 1.

Always worked just fine.

Today, when I clicked on the Chart 1Tab on the bottom to see the new graph, all my graph lines and curves have totally disappeared.
The x and y axes are still there, as are the axis labels.

But no graph. Totally wiped out.

What might have happened, please ?
All I did was simply click on the bottom tab that said Chart 1. Honest.

**How can I possibly get it back without having to go thru a whole new graphing
sequence ?

How do I prevent this from happening again ?

Was it something I (likely) did ?

Much Thanks,
Bob