Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!
Subscribe for Free Excel tips & more!

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 Tutorials

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 ...
Change the Name of a Chart in Excel
How to change the name of a chart in Excel. This allows you to use a more intuitive chart reference when organizin ...
How to Create and Manage a Chart in Excel
In this tutorial I am going to introduce you to creating and managing charts in Excel. Before you create a chart yo ...
Prevent Charts from Printing in Excel
This is how you prevent a chart from appearing when you print from Excel. This is a great feature when you want to ...

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

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.


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


I have a spreadsheet that I use to track production for a real estate team. One of the columns is the Source of their business (Referral, Sign, Website...etc) which is a drop down list.

I would like to create a pie chart or graph to show the percentages of where the Sources come from.

Please guide me. I am an Excel kind!

Thanks to any and all!!!


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?


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".



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.

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 the chart is the INPUT to a spreadsheet's data.


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

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

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.


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?


I am pretty new to Powerpivot and therefore not sure how crazy of a request this is, but here goes.

On the attached spreadsheet on the Oil 7 Day Avg tab there is a pivot table and chart created using powerpivot. I need to remove all blank (zero production) data from this chart. The reason there is zero production data is because I have "Days" in the in the row label currently. I think this is what I need to replace with a new calculated measure but I am not sure how to do it or if that would fix it.

I want to remove all the blank production from each category and have the row labels 0 to the nth row.

The goal is to smooth out the chart. It is supposed to be non zero production(y) vs the number of days there was non-zero production(x) for each category.

Is this possible?

Hello all! I'm new to this forum and I'm kind of a hack in excel. I don't really know what I'm doing, but somehow I've been able to get it to do pretty much anything I've ever really wanted. Until now!

So what I would like to do is this:

1) I would like to use existing data to plot a graph curve. It will have the start date through end date of a production run, as well as number of units made each day.

This part I figured out: the next I can't seem to get.

2) I would like to enter a different size production run, and a different number of total units to create a new graph. This graph's shape is exactly proportional to the first.

* In other words, the second graph input is only the number of units and number of days-- I want to generate a rough prediction of how it will fluctuate assuming it will look like the first graph.

Any guesses?

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?

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?


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,

I need help with a bar graph/chart. I have the chart almost complete I just need to add another set of data on the horizontal axis that is identical to the one already in it... I'd learn it myself but googling really doesn't help since the terminology for this stuff is so damn similar for everything.

Example of data:

Question 1 Reponse Percent
Yes 96%
No 4%
Question 2
Yes 95%
No 5%
Question 3
Yes 90%
No 10%

My problem is that I can't get the bar graph/chart to add Question 2 and 3 to the horizontal Axis. I have the bar graph/chart exactly the way I want it to look for Question 1 though.

I attached a copy of the excel file and the chart is open and ready to go.

Thanks in advance for advice.

Hi All,

I have a Excel chart which can plot daily power consumption again the production Qty. Now the excel chart start the plot time on X Axis from 00 Hr and end at 23:59 hour.

Now i need to change the start plot time on X Axis at 8:00 Am and end at 8:00 Am.

So that this way i can compare the Shift 1 and shift 2 production Qty ver power consumption. As during the 2nd shift the worker keep the machine running and production Qty is very low , this is because during 4 am till 5 Am usually production Qty low and power consumption remain the same.

Hope some one can help me.


i'm new to charting so be gentle. i have a production bar chart reflecting monthly scrap rates and i would like to insert a target line at 1% across the entire production year. help....


I am new to this forum and need some help. Any feedback would be highly helpful for me.

I have half hourly data for production. I want to create dynamic comparison chart in which I can compare any present day with last year same day i.e comparing the production on 2 feb 2007 with 2 feb 2008.

I also want to do monthly comparison i.e Jan 2007 with Jan 2008.
I would like to make it dynamic by changing the chart by clicking a button for day by day of month by month.

I want date on x axis and production data on Y axis.

I have attached a sample test for reference.

Thanks in advance,


I have created some Excel Pivot Charts based on my pivot tables. The values are a COUNT and a %OF column.

For my chart, I selected the bar graph option, kept the COUNT as a bar graph, and changed the %OF to a line graph cutting through the COUNT bars with the data label above it.

However, when selecting a row value from the pivot drop-down that doesn't have data for it, the pivot table and chart go blank. Understandable. But when I then select a row value for which there is data, the chart always defaults back to a bar graph for the %OF.

Is there any way to "lock-in" how the chart is structured?

Edit: Even tried placing %OF as a secondary axis, but the same problem still occurs.

I want to combine a histogram with an xy graph, but the only possibilities are either to combine a bar-graph with a line graph or to combine an xy-graph with y-error bars.

Neither is very good for my purpose, but the latter is the least bad, and I try to improve by chosing the thickest possible line for the error bar. I wonder if it were possible to make those errorbars even broader - perhaps as broad as a histogram bar?


Hey everyone,

I have created some charts for my work and one of them is a line chart that spreads across one year with values for each month. Well they want the graph to always show one month ahead of where we are out. So there is actuals in for Sep. but then the line graph drops all the way to 0 for Oct. I don't want to have the graph bottom out when there is a zero. Does anyone know how to fix this?

I'm creating a production sheet and I have created a list using Data Validation for the different types of production but I had to create another list for the production standard (the # units per hour). Is there a way to set it up so by selecting a type of production it auto fills the production standard?