How Do You Graph A Ppf (production Possibilities Frontier) Chart . 
New Excel Help Service!
We need your input to help create a new Live Online Excel Help service.
Please take our survey and let us know your thoughts!
Have a great day!
Don


Similar Excel Tutorials
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 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 ...
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 ...
This is how you prevent a chart from appearing when you print from Excel. This is a great feature when you want to ...
Make a Transparent Chart in Excel
How to make a Chart transparent so that it blends in with its background and surroundings in Excel. Hover your mous ...
How to make a Chart transparent so that it blends in with its background and surroundings in Excel. Hover your mous ...
Combine Multiple Chart Types in Excel to Make Powerful Charts
In this tutorial I am going to show you how to combine multiple chart types to create a single chart in Excel. This ...
In this tutorial I am going to show you how to combine multiple chart types to create a single chart in Excel. This ...
Connect the Line for a Chart in Excel and Skip Blanks
How to prevent a line chart from having a blank spot or also dropping to zero when there is a blank cell or a zero ...
How to prevent a line chart from having a blank spot or also dropping to zero when there is a blank cell or a zero ...
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
 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
 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
 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
 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
 This macro will print every embedded chart in the active workbook. If you have an embedded chart in any worksheet within
Similar Topics
How to plot efficient frontier from sets of data containing expected return,
average return, variance, standard deviation, covariance and correlation ?
average return, variance, standard deviation, covariance and correlation ?
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.
Hello.
I run a production planning departement and I need to do a simple mrp from the current production plan.
The production plan is made in excel:
Day 1 Day 2
Part 1 100pcs 200pcs
Part 2 20 pcs 10pcs
In Part 1 and 2 there are several part numbers that are assembled to it.
I have chart with these part numbers like this:
Part100 Part200 Part300
Part 1 3pcs 2pcs 3pcs
Part 2 23pcs 10pcs 21pcs
I would like to have place in my chart that multiplies the current production plan for all part numbers and creates a total sum of demand for part100, part200 and so on.
I have attached an document with a lot of Index and Match functions but I can't make this work.
Is there som kind person with the knowledge to hack this problem?
/Anders
I run a production planning departement and I need to do a simple mrp from the current production plan.
The production plan is made in excel:
Day 1 Day 2
Part 1 100pcs 200pcs
Part 2 20 pcs 10pcs
In Part 1 and 2 there are several part numbers that are assembled to it.
I have chart with these part numbers like this:
Part100 Part200 Part300
Part 1 3pcs 2pcs 3pcs
Part 2 23pcs 10pcs 21pcs
I would like to have place in my chart that multiplies the current production plan for all part numbers and creates a total sum of demand for part100, part200 and so on.
I have attached an document with a lot of Index and Match functions but I can't make this work.
Is there som kind person with the knowledge to hack this problem?
/Anders
Hi!
I want to create a graph of weight loss that can be tracked based on progress. It would be a line graph that would automatically change as you entered your weight for each date. I found a graph online that did this but I believe he has a weight cap or range because anything less than 165 would not show up on the chart. I can send or attach the graph if neccesary.
I also wanted a second series or line that would show the increase and decrease of calorie intake.
Thanks in advance for your help.
I want to create a graph of weight loss that can be tracked based on progress. It would be a line graph that would automatically change as you entered your weight for each date. I found a graph online that did this but I believe he has a weight cap or range because anything less than 165 would not show up on the chart. I can send or attach the graph if neccesary.
I also wanted a second series or line that would show the increase and decrease of calorie intake.
Thanks in advance for your help.
Hi all
I am new to this site and what a great forum. I found the following link very useful to create a chart from the likert scales.
http://www.excelforum.com/excelchar...gachart.html
But, I would like to change the legend as per the graph from Strongly disagree to strongly agree in that order. I tried just moving them around in the data table, but it seems to move the whole graph and so, the original graph gets distorted. Any ideas how this might be done or is it not possible. Thanks.
Raja
I am new to this site and what a great forum. I found the following link very useful to create a chart from the likert scales.
http://www.excelforum.com/excelchar...gachart.html
But, I would like to change the legend as per the graph from Strongly disagree to strongly agree in that order. I tried just moving them around in the data table, but it seems to move the whole graph and so, the original graph gets distorted. Any ideas how this might be done or is it not possible. Thanks.
Raja
Hi all
I am a biochemist so excuse me if I do not use the correct terms.
I have a practical problem with a set of data that I am receiving through one of my experiments. I am logging the production of biogas as a function of time. The production is not linear but increases and decreases (slowly) depending on the parameters I vary.
My flow meter logs accumulated gas production, however it would be much more informative for me to be able to display the gas production rate (as a function of time) in a graph.
My thought is that this can be done by looking at the slope of the curve as a function of time (the differential to the curve), but I dont want to do this by simply subtracting two adjacent data points as this would be too inaccurate.
Does anyone know of a way to do this? Is it possible to get excel to take the slope of a curve for any point on that curve, based on (for example) an approximated curve fit equation.
Regards
Stefan BG, Denmark
I am a biochemist so excuse me if I do not use the correct terms.
I have a practical problem with a set of data that I am receiving through one of my experiments. I am logging the production of biogas as a function of time. The production is not linear but increases and decreases (slowly) depending on the parameters I vary.
My flow meter logs accumulated gas production, however it would be much more informative for me to be able to display the gas production rate (as a function of time) in a graph.
My thought is that this can be done by looking at the slope of the curve as a function of time (the differential to the curve), but I dont want to do this by simply subtracting two adjacent data points as this would be too inaccurate.
Does anyone know of a way to do this? Is it possible to get excel to take the slope of a curve for any point on that curve, based on (for example) an approximated curve fit equation.
Regards
Stefan BG, Denmark
i want to plot a saw tooth graph. this is like an inventory graph where there
is production and instantaneous consumpltion
is production and instantaneous consumpltion
Hi everyone. This has bugged me for a while but I never thought to ask until now.
When you have a graph referencing some data close to it, when you click on the chart/graph it will outline the data it's referencing in blue, the series names in green, and the X axis names in purple (for a bar/line graph). This is a very useful function and I end up using it quite a bit.
The problem I'm running into is that sometimes after creating a chart, I will click on it and and it will outline everything in the data that I stated above. Then 5 minutes later I will click on the same chart and it won't outline any of the data and I can't figure out what has triggered this change. Does this happen to anyone else? Is this a bug or am I doing something wrong? Look forward to hearing from everyone.
(Sorry to post this in two forums, I didn't see that there was a forum specifically for graphs)
When you have a graph referencing some data close to it, when you click on the chart/graph it will outline the data it's referencing in blue, the series names in green, and the X axis names in purple (for a bar/line graph). This is a very useful function and I end up using it quite a bit.
The problem I'm running into is that sometimes after creating a chart, I will click on it and and it will outline everything in the data that I stated above. Then 5 minutes later I will click on the same chart and it won't outline any of the data and I can't figure out what has triggered this change. Does this happen to anyone else? Is this a bug or am I doing something wrong? Look forward to hearing from everyone.
(Sorry to post this in two forums, I didn't see that there was a forum specifically for graphs)
Hi
Is it possible to have a chart or graph appear on a VBA userform, dynamically updated with it's source data on a hidden worksheet?
I've tried inserting a microsoft chart onto a form but it seems to be different from an excel chart, and I cannot get it to take data off a worksheet.
Using Excel 11.
thanks
Mike
Is it possible to have a chart or graph appear on a VBA userform, dynamically updated with it's source data on a hidden worksheet?
I've tried inserting a microsoft chart onto a form but it seems to be different from an excel chart, and I cannot get it to take data off a worksheet.
Using Excel 11.
thanks
Mike
I have a worksheet that contains a graph. Every once in a while the graph will hide form me. I can update it, print it but I can't see it. The next time I open the workbook it appears again.
What is going on?
How can I make my graph visible again?
Steve Druley
What is going on?
How can I make my graph visible again?
Steve Druley
I'm working on implementing a waterfall chart into some month end cash flows charts and am having trouble with the scale. I have an inflow that is infinitely bigger than all the other inflows and am wondering how to "hide" a portion of the graph so all the inflows show up on the graph. Just for examples sake let's say, most of my inflows are $1000 but one is $1,000,000. Is there a way to insert a break in the graph to cut out $300,000$700,000?
I am using Microsoft Excel 2003
I am using Microsoft Excel 2003
Hi! I currently have the below is an excerpt of code that works to give me a bar graph for one set of data. I would be interested to know if any one on here knows how to take my code below and alter it so it gives an output of a combination graph (Bar and line Graph). The bar graph would be the same set of data it is pulling now from a pivot table. The line graph data would be on a different worksheet in a table. Please let me know if you need any more info. thanks!
[code]
Dim shp As Shape
Set shp = ActiveSheet.Shapes.AddChart(xlColumnStacked)
shp.Chart.SetSourceData Source:=ActiveSheet.PivotTables(1).TableRange1, _
PlotBy:=xlColumns
Dim objChart1 As ChartObject
Set objChart1 = Sheets("Upcoming Quarter Requirements").ChartObjects(1)
With Range("B13:C22")
shp.Left = .Left
shp.Top = .Top
shp.Width = .Width
shp.Height = .Height
End With
With shp.Chart.PivotLayout.PivotTable
.PivotFields("Resource Assigned").Orientation = xlRowField
End With
shp.Chart.ChartType = xlColumnStacked
[\code]
Good morning all,
I've seen this problem posted before on MrExcel.com, but none of the threads have a working answer yet.
The problem is that the values in my graph lose their decimal precision when the spreadsheet holding the source values in not actively open.
I have two spreadsheets ("A" and "B") and spreadsheet A has a chart whose source data in found in spreadsheet B. (The graph is just a line graph, with the actual plotted values displayed at the bottom of the graph in a chart). The source values in spreadsheet B look as follows:
6% 8% 1% 6% 18% 18% 23% 18%
(point being, no decimal precision displayed. The true values do have decimal precision).
When both spreadsheets are open, the chart in spreadsheet A displays the values exactly as they appear in spreadsheet B. The problem is that if I simply close spreadsheet B and then view the values in the chart, they have all reverted to showing the full decimal precision that is stored in the cell from spreadsheet B.
Does anyone know how to fix this? I am using MS Excel 2007.
Thanks so much!!!
Mark
I've seen this problem posted before on MrExcel.com, but none of the threads have a working answer yet.
The problem is that the values in my graph lose their decimal precision when the spreadsheet holding the source values in not actively open.
I have two spreadsheets ("A" and "B") and spreadsheet A has a chart whose source data in found in spreadsheet B. (The graph is just a line graph, with the actual plotted values displayed at the bottom of the graph in a chart). The source values in spreadsheet B look as follows:
6% 8% 1% 6% 18% 18% 23% 18%
(point being, no decimal precision displayed. The true values do have decimal precision).
When both spreadsheets are open, the chart in spreadsheet A displays the values exactly as they appear in spreadsheet B. The problem is that if I simply close spreadsheet B and then view the values in the chart, they have all reverted to showing the full decimal precision that is stored in the cell from spreadsheet B.
Does anyone know how to fix this? I am using MS Excel 2007.
Thanks so much!!!
Mark
Hi, I know this might be a stupid question but is it possible that values will not overlap when being display on a chart. I have a set of values entered in and they are then graphed on a chart. When graph i do not want my values to overlap and look untidy. Is there a way this can be stoppd?
Thanks
Thanks
Hi
I need to generate monthly charts. There are 14 chart in my sheet. I need to write a macro so that all those graph are automatically updated with new month's data. For that the macro should:
Select the graph sequentially. (one after other)
Select the data
Add one more row(data of month)
update the graph
I tried different ways but
anyone any suggestion
I need to generate monthly charts. There are 14 chart in my sheet. I need to write a macro so that all those graph are automatically updated with new month's data. For that the macro should:
Select the graph sequentially. (one after other)
Select the data
Add one more row(data of month)
update the graph
I tried different ways but
anyone any suggestion
Hi,
I'm using an XY scatter graph, and need to copy the same graph and its range data multiple times and would like the reference source data for each graph to change relatively. When I make the copy of the graph and source data and paste elsewhere  the graph still references the source data of the original graph. The source data seems to turn into absolute but even if I remove the $ from the formula, it simply reappears.
Thanks for your help.
Emer
I'm using an XY scatter graph, and need to copy the same graph and its range data multiple times and would like the reference source data for each graph to change relatively. When I make the copy of the graph and source data and paste elsewhere  the graph still references the source data of the original graph. The source data seems to turn into absolute but even if I remove the $ from the formula, it simply reappears.
Thanks for your help.
Emer
Hello
I have created a floating bar chart using the up/down bars. The bars represent high and low salary ranges. (salaries on the x axis and salary grade label on the Y)
In the same chart I would also like to show actual salaries represented in a scatter graph format
Any help would be much appreciated
I have created a floating bar chart using the up/down bars. The bars represent high and low salary ranges. (salaries on the x axis and salary grade label on the Y)
In the same chart I would also like to show actual salaries represented in a scatter graph format
Any help would be much appreciated
Hi everyone,
I am a teacher and want to create a specific chart to track academic target levels against current the levels students are achieving.
My idea is to create a chart with 3 circular bands to it, Green, Amber and Red  starting from the centre and working outwards. Ideally I would like the graph to show students who were closer to their target level in the centre (Green band), with those students who were further away from their targets being placed further out on the graph (Amber) and those way off in the Red band.
Just wondering if someone could give me some advice on how to create such graph.
many thanks,
I created a production tracking worksheet (see attachment), that breaks down everything that we want. But we need something visually that shows how far along they are while working. On their desk they have a Standard Production Job Aid (see 2nd tab) that's laminated so they can use it multiple times. They cross off the amount of claims they have worked (stick = 30 min). It's a tall order but if anyone has any suggestions on how to make the second tab reflective of the work in the first tab, it would make a lot of people happy. The first tab is broken up into formulas (shaded part they do not touch) and entry cells (clear cells they enter their production count and hours worked). I have been messing around with a chart but not sure if that's the best way. If it could some how shad or change the color of the stick part to the amount of claims worked that would be ideal. Any suggestions will be helpful.
Thanks again,
Seahawk56
P.S. I just found out you can not attach a workbook and I can't figure out the htmlMaker form Colo. If you are interested in trying to answer this, please reply with an email address and I will email it to you. Or if someone knows a better way let me know. Thanks again!
Thanks again,
Seahawk56
P.S. I just found out you can not attach a workbook and I can't figure out the htmlMaker form Colo. If you are interested in trying to answer this, please reply with an email address and I will email it to you. Or if someone knows a better way let me know. Thanks again!
Hi, i'm trying to plot the Markowitz efficient frontier in Excel. I have returns and other data for 20 stocks.
I use solver to find the optimal weights of the 20 stocks for the the lowest variance portfolio.
I need to then find the weights of the stocks from this point to the highest possible return portfolio.
Finding the portfolio with the smallest variance and with the highest return is fine with solver, i just use the min and max functions.
How do i find the points in between?
For example, the return on my minimum variance portfolio is 1, the return on my max return portfolio is 100. Right now, i would need to run optimizer with minimum variance for the returns of 2,3,4....all the way to 99 to find those points.
Any shortcuts or add ins?
Thanks
I use solver to find the optimal weights of the 20 stocks for the the lowest variance portfolio.
I need to then find the weights of the stocks from this point to the highest possible return portfolio.
Finding the portfolio with the smallest variance and with the highest return is fine with solver, i just use the min and max functions.
How do i find the points in between?
For example, the return on my minimum variance portfolio is 1, the return on my max return portfolio is 100. Right now, i would need to run optimizer with minimum variance for the returns of 2,3,4....all the way to 99 to find those points.
Any shortcuts or add ins?
Thanks
Hi All,
I am working with a pivot table and using a pivot chart from the data. The chart I need to use is a horizontal colour coded bar chart. The chart and labels accurately show the data. The problem is with the legend. I will give a simple example.
Chart Legend
A  30% D
B  73% C
C  15% B
D  29% A
On the example above, treat Chart and Legend as different rows.
The colours on the chart are matched with the colours on the legend correctly, so A would be for example red on both the chart bar and the legend, but it looks confusing as the legend is in an opposite position to the bar it refers to.
I am using excel 2007 and I need to keep the order of the chart bars as they are following legacy printed charts, I just need the legend to work correctly.
Any ideas?
I am working with a pivot table and using a pivot chart from the data. The chart I need to use is a horizontal colour coded bar chart. The chart and labels accurately show the data. The problem is with the legend. I will give a simple example.
Chart Legend
A  30% D
B  73% C
C  15% B
D  29% A
On the example above, treat Chart and Legend as different rows.
The colours on the chart are matched with the colours on the legend correctly, so A would be for example red on both the chart bar and the legend, but it looks confusing as the legend is in an opposite position to the bar it refers to.
I am using excel 2007 and I need to keep the order of the chart bars as they are following legacy printed charts, I just need the legend to work correctly.
Any ideas?
I am still pretty new to VBA, I have array held in VBA code, what is the best what to get it into a chart?
I was after a bar chart, and the data for the chart will update once every 5 mins or so from the array so how do i keep this graph updated
thanks
Tinkerz
I was after a bar chart, and the data for the chart will update once every 5 mins or so from the array so how do i keep this graph updated
thanks
Tinkerz
Hi,
I have 3 different things that I want to graph vs. time on the same graph. I wanted to do a line graph but I would have to have three different yaxes for each set of data. Is is possible to graph all three in an intelligent way on a line graph? Or is there another graph that would work better?
I have 3 different things that I want to graph vs. time on the same graph. I wanted to do a line graph but I would have to have three different yaxes for each set of data. Is is possible to graph all three in an intelligent way on a line graph? Or is there another graph that would work better?
Hello,
I would like to create a chart similar to what excel creates for you when you use the pivot chart wizard. Specifically I would like the drop down menus with clickable boxes to select a piece of data and plot it on a graph.
I am familiar with creating drop down lists using data validation, but I am stumped on how I create a selectable drop down list.
Basically I wish I could just add data to the pivot table chart as I want to graph data against pivot table data on the same chart, but I don't think that is possible.
Thanks in advance!
I would like to create a chart similar to what excel creates for you when you use the pivot chart wizard. Specifically I would like the drop down menus with clickable boxes to select a piece of data and plot it on a graph.
I am familiar with creating drop down lists using data validation, but I am stumped on how I create a selectable drop down list.
Basically I wish I could just add data to the pivot table chart as I want to graph data against pivot table data on the same chart, but I don't think that is possible.
Thanks in advance!
Hey everybody,
I tried searching and couldn't come up with anything. How do you adjust the spacing between clusters in a clustered column bar graph? I've attached an image of what I want the final graph to look like, and how I've got it so far. The spacing that Excel generates for my graph (on the left) is far too wide and looks a bit weird. The graph on the right was made in Adobe Illustrator, but I'd like to generate it completely from Excel without any touch ups.
Thanks for the help!
I tried searching and couldn't come up with anything. How do you adjust the spacing between clusters in a clustered column bar graph? I've attached an image of what I want the final graph to look like, and how I've got it so far. The spacing that Excel generates for my graph (on the left) is far too wide and looks a bit weird. The graph on the right was made in Adobe Illustrator, but I'd like to generate it completely from Excel without any touch ups.
Thanks for the help!