i am trying to export a graph from excel into my presentation in power point. Is there a way to do that? lisajensen21 Wrote: > i am trying to export a graph from excel into my presentation in power > point. > Is there a way to do that? Hi. Just click on the chart so that you get black dots at the corners and mid points of the chart Then go to Edit - copy. Open the powerpoint page you want and then make a text box Click inside the text box and then go to Edit - paste. HTHs -- badkitti* ------------------------------------------------------------------------ badkitti*'s ...

I would like to be able to tell if a cell is being used in any graph in my workbook. The standard <Audit> <Show dependants> does not seem to concider Graphs as dependents (Help specifically talks about dependent "cells" in the auditing write up) Is anyone aware of a built in method for determining whther a cell is used in a chart, or does anyone have a recomended macro I can build on? You are right in that the 'Show Dependents' doesn't consider graphs as dependents. In fact, there is no easy way to find all the cell references in a workbook. As f...

All, This is just my thought but have no idea how to proceed. Can someone please provide a solution, I will really appreciate. Not sure how to attach a spreadsheet by my data spreadsheet is uploaded to File section known as DATA.XLSX. Col A. contains dates ( 1-Jan to 16-Aug ) and Col B-K contains data starting year 2001-2010 for the same dates. I would like to create a Date Range Input box so whenever I specify date ranges, it automatically pulls data of those dates from 2001 to 2010 and creates some type of line chart. E.g I specify date1: 3-march and date2: 10-June then line graph sho...

I have created stacked column graphs using the OFFSET function to automatically update when each week's information is added to the worksheet. However, now my boss want's only the last 4-6 weeks of information to be displayed on the graph. Is there a way to do this without manually changing each data point (there are 6 for each week for each chart--YIKES) every week? Thank you for your time, Dee I found it! http://www.peltiertech.com/Excel/Charts/DynamicLast12.html "Dee Sperling" <sperling@infimed.com> wrote in message news:uE$hZxiLFHA.3064@TK2MSFTNGP12.phx.gbl....

I read an enlightening, pro-mac article inferring that Microsoft's discontinuation of IE development is one indication the plug might be pulled on Office as well. Is there any reassurance out there that this won't happen? This is a quote from Jessica Sommer [MS]: "We are working diligently on the next version of Office -- these [IE and Office] are not connected in any way. Office is still intact and going strong -- there are no plans to stop development on Office for Mac even after the next version is released." <http://maccentral.macworld.com/news/2003/06/13/explorer/&g...

I have two lines one linear (y=mx+c) and one exponential (y=c^bx) and they intercept each other. I believe it is possible to calculate where the lines intercept. Although I can do this by graphing the data, it takes time and allows for user error so a calculation would speed things along greatly. The problem: So for the first line using the equation y=mx+c the numbers for the 13kPa line are y=0.0021x+9e-16 And for the exponential line (y=c^bx) which we produce to using the myograph is y=0.0022^0.0046x (^=Exp) I know that the two lines intercept at 1613. But no matter what I try I can&...

If it were possible to scroll all the Graphs using the mouse wheel (or page up/down or Up/Down Arrow) would be a very useful tool to display all the items in the portfolio very quickly. Currently, I have to return to the portfolio and select the investment and return to the graph display. Using the "Compare to" feature does not answer the issue. Also, when using the "Compare to" feature, Buy/Sell tags does not display. This would be nice also. Anyone agree? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions w...

Need help in creating chart graph. For example, we have tarped and untarped data we need to track. I want to create a chart for 9 landfill sites and show the tarped and untarped percentages on the same bar graph. I am comparing October and November data. I am using excel 2003. Does anyone know if this can be done? The chart wizards has something similar, but not showing the data the way we want to present it. Thanks! Neither of your posts described what you want to show, or how you want to show it. I'm sure what you want can be done, but I don't know yet what that is. -...

In Excel how do you set up a 3 variable linear programming problem on a spreadsheet with a a number of constaints using Solver? Franklin - See the tutorials and examples at www.solver.com. Or, search your drive for the file solvsamp.xls, which is installed when Solver is installed and which has a 3-variable nonlinear example that is easily converted to linear. - Mike www.mikemiddleton.com +++++++++++++++++++ "Franklin" <anonymous@discussions.microsoft.com> wrote in message news:0c5a01c500bf$8f5038c0$a501280a@phx.gbl... > In Excel how do you set up a 3 variable ...

I want to graph the linear equation y = 2x + 4 in microsoft excel. How do I do this? On my TI-83 Plus I could easily do this. I also know I could create a data table and use the table of values to chart the line in excel. But I want just enter the equation in excel and have excel graph it. Thanks. On Sun, 9 Jan 2005, in microsoft.public.excel.charting, Throstle <Throstle@discussions.microsoft.com> said: >I want to graph the linear equation y = 2x + 4 in microsoft excel. How do I >do this? On my TI-83 Plus I could easily do this. I also know I could create >a data table and ...

Can someone explain how to do a graph? Specifically for a finance class. I need to do a breakeven graph and a EBIT-EPS indifference graph. Select a cell that is in the table that you want to graph, then press F11. What you graph will depend on what variables you have available to base your calculation on. eg. variable / fixed costs, etc. Steve Kellique wrote: > Can someone explain how to do a graph? Specifically for a finance class. I > need to do a breakeven graph and a EBIT-EPS indifference graph. ...

Hi, A frequent function of my job is to analyse data on graphs/charts to extract data for engineering data , i.e power / temperature/flowrates etc etc Is the a microsoft based programe i.e. Excel/Access that is capable of understanding data on a scaled X-Y axis that if an X value was entered in a cell, the programme would extract a corresponding Y value from a line on a graph ? If anyone has any woring examples of such a thing, I'd appreciate a link Thx Hi, If there is a linear relationship between X and Y use the function FORECAST It a power series is needed use LINEST - see examp...

Hi, I have been trying to write a legend in a graph which has some of its part subscripted. However, I have not been able to do so. Could anybody show me a way out. nure If your superscripts are just 2 and 3 (squared and cubed) then for toy axis header use something like y +ALT0179 or y+ALT0179 (digits on the number pad) to get y� and y� For other digits you need a fond such as Chemistry font (see http://www.scs-intl.com/frameload.htm?/chemfont.htm) which has sub and superscripts for all digits. So does the Calibri font in Office 2007 but they do not have sequential ASCII values. See...

I have five numbers in: A1,B1,C1,D1,E1 Is there a function that will give me the linear regression of those numbers that can be put in D1, with charting etc? TIA Linear regression works with ordered pairs. row 1: 1,2,3,4,5 row 2: 2,4,6,8,<formula> formula in E2 : =FORECAST(E1,A2:D2,A1:D1) will return 10 Any use? best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Saxman" <john.h.williamsREMOVETHIS@btinternet.com> wrote in message news:XpidnXpInZMDMx7WnZ2dnUVZ8m1i4p2d@bt.com... > I have five numbers in: &...

Hi, i have a spread sheet that i am trying to form a line graph to show the amounts paid in that period and in this period. how do i go about with the formula that i need to through. thanks EXCEL 2007 Hi Ray, please check out:- http://www.pierrefondes.com/ - item number 55. All you need to do is to adapt this to you own needs. If my comments have helped please hit Yes. Thanks. "ray" wrote: > Hi, > > i have a spread sheet that i am trying to form a line graph to show the > amounts paid in that period and in this period....

I am having difficulty graphing a linear equation in two variables by using three ordered pair 1/2 y = 2x + My ordered pair x 0 1 y 2 6 10 see as follow Pairs x (0, 2 (1, 6 (2, 10 I am unable to graph this problem and need help!!! Just select the range containing the ordered pairs and Insert|Chart. Jerry Angela Mitchell wrote: > I am having difficulty graphing a linear equation in two variables by using three ordered pairs > > 1/2 y = 2x + 1 > > My ordered pairs > x 0 1 2 > y 2 6 10 see as follows > > Pairs: > x y > (0, 2) >...

Hi, I am kind of new to excel and was wondering if excel is capable of doing linear increments. I want increments that can vary, meaning in one case i want to go from 0 to 10 in increments of 2 and in other cases i want to go from 0 to 10 in increments of 5. The number of cells change. Is it possible for excel to do this w/o having to specify the number of cells needed? -- NewGuy100 ------------------------------------------------------------------------ NewGuy100's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27935 View this thread: http://www.excelforum.com...

I only use Money 2006 to track my investments and have set up a file to include one account which contains a certain type of investment. All investments in that account have now been sold. Why is it that when I go to monthly reports, under 'Performance of Your Investments", it registers a percentage reading and underneath it says "This year investments in your account have outperformed all other investment accounts..." Most of the investments have been completely sold for several years although one was last sold late last year? I have checked previous monthly repor...

I have created an xy scatter graph that draws a rectangular shape. The rectangle is rotated based on an input angle which varies. (0<angle<=90). It appears to be rotating correctly, but as it does, there is some distortion so that the rectangle becomes a parallelogram. Is there any way to correct that? there's a newsgroup devoted to graphing. news://msnews.microsoft.com/microsoft.public.excel.charting If you don't get a reply, you may want to visit there. There's less traffic there and those charting experts may see your question (instead of having it buried in thi...

I am a recent convert from Quicken, and I'm just getting used to the features of Money. One thing I really liked, in Quicken was the bar graph that showed up under the Calendar that would show a bar graph of the balance in an account of my choosing. This was great because I could quickly see if I was going to head into the negative anytime soon and make spendnig adjustments. I can't find anything similar in Money. Is there something like that? Thanks. The "forecast your cash flow" page is probably what you require. Click on 'cash flow' in the menu on the le...

I want to make an adjustment to the order on the X axis. I have my months listed in this order in the source range: March (listed vertically) April May My chart shows this order: Apr May Jun........Mar When I reverse them I get Mar Feb Jan.......Apr I want Mar Apr May.... (the way I have it listed in the source range) What I want to present is how this month's data relates to the same month last year then give a head's up on what to expect next month.... Hi, The only thing I can think of that would change the order of the axis labels is that there are really dates. And that t...

In a1:a10 enter numbers such as 1,2,3.... In b1 type =a1^2+3 copy this down to B10 select a1:b10; click chart wizard; select XY chart done now play with values in A to get what you need best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Max" <Max@discussions.microsoft.com> wrote in message news:F72AB641-F882-4DAD-B0C3-322297A124FC@microsoft.com... > ...

I am trying to plot quarterly and monthly data using two lines. My quarterly line is broken into points instead of a continuous line, is there a way I can get it to connect to the quarter points? If the cells in between are blank, go to Tools menu > Options > Chart tab, and choose the Interpolate option for dealing with blank cells. If the cells contain anything else, including a formula that returns "" (which is NOT blank), change "" to NA(), which puts an #N/A error in the cell, which ain't pretty in the worksheet but which results in an interpolated lin...

Can I add a second X axis value on both left and right sides of a chart? At present scrolling the chart to the right there are no axis label values to easily read the chart. Beemer Beemer, You have to have at least two Data Series to do that. Right click on the second of them, choose Format Data Series, then on the Axis tab, choose secondary axis. Note that Excel may change the relative values between the first and second axes, so you should set the Max and Min for both manually. HTH, Bernie MS Excel MVP "Beemer" <Beemer@nowhere.com> wrote in message news:MPG.1b2a2779...

Try using this white space to ask you question with a bit more detail best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "mattz" <mattz@discussions.microsoft.com> wrote in message news:574CCC66-72EA-44D0-8D36-2147B6C7C279@microsoft.com... > ...