how do i export a graph from excel to power point?
i am trying to export a graph from excel into my presentation in power point.
Is there a way to do that?
> i am trying to export a graph from excel into my presentation in power
> Is there a way to do that?
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.
badkitti*'s ...Auditing and graphs
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...Graph and Input box for Date Range
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...Sliding dates on a graph?
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
Thank you for your time,
I found it!
"Dee Sperling" <firstname.lastname@example.org> wrote in message
news:uE$hZxiLFHA.3064@TK2MSFTNGP12.phx.gbl....Microsoft Office X Future
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
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...linear and exponential graphs and x,y intercepts
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.
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&...Srolling Price History Graphs
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.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions w...Need help with chart graph not on chart wizard
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
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.
"Franklin" <email@example.com> wrote in message
> In Excel how do you set up a 3 variable ...how do I graph a linear equation?
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 ...Graphs #9
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.
> 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.
...using linear / non linear graphs to extract results
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
If anyone has any woring examples of such a thing, I'd appreciate a link
If there is a linear relationship between X and Y use the function FORECAST
It a power series is needed use LINEST - see examp...Subscripted text in the legend of a graph
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.
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.
I have five numbers in:
Is there a function that will give me the linear regression of those
numbers that can be put in D1, with charting etc?
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
Microsoft Excel MVP
"Saxman" <john.h.williamsREMOVETHIS@btinternet.com> wrote in message
> I have five numbers in:
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.
Hi Ray, please check out:-
- item number 55.
All you need to do is to adapt this to you own needs.
If my comments have helped please hit Yes.
> 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....Linear Equations
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
I am unable to graph this problem and need help!!!
Just select the range containing the ordered pairs and Insert|Chart.
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
> x y
> (0, 2)
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's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27935
View this thread: http://www.excelforum.com...Performance Graph in Monthly Reports
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...Printed scalable graphs
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.
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...Account Balance Graph
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?
The "forecast your cash flow" page is probably what you require. Click on
'cash flow' in the menu on the le...Control X axis order
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)
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....
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...How can I draw a Parabola in Excel? like y = x^2 + 3
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
now play with values in A to get what you need
Bernard V Liengme
remove caps from email
"Max" <Max@discussions.microsoft.com> wrote in message
...2 Lined Line Graph
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...Chart X Axis value label on both left and right sides
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.
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.
MS Excel MVP
"Beemer" <Beemer@nowhere.com> wrote in message
news:MPG.1b2a2779...Excel 2007; graph the best fit line from a regression analysis?
Try using this white space to ask you question with a bit more detail
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"mattz" <firstname.lastname@example.org> wrote in message