can excel automtically graph things with given data?
I have to do a lab report for school and my teacher told me to go on excel
and insert the data that it will automatically give you a line graph with a
best-fit line. Please help me!!!!!!!!!!! Thank you
Start by putting the first x-value in cell A1 (the cell under column A, next
to row 1). Put the other x-values below this.
Put the y-values in column B
Select any one of the cells with data; click the chart wizard on the tool
I expect you want an XY chart
Now you can experiment; make the chart large/smaller; change the scale; etc.
See if there is an Excel book in the school library
Or v...FWD: Check out these correction update from the M$ Corp.
Content-Type: multipart/related; boundary="qppmlrszzh";
Content-Type: multipart/alternative; boundary="asqpqfesvtq"
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which resolves
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to continue ...Text boxes on graphs
How do you make a text box hide the grid lines behind it on a graph? The
grid lines are still visible and run through the text box, cluttering it up.
right-click text box
choose -- 'Format Text Box' from shortcut menu
colors and lines tab
change fill color to white
remote programming and training
8-part free tutorial that covers essentials in Access
(: have an awesome day :)
> How do you make a text box hide the grid lines behind it on a graph? The
> grid line...Graph control with input
Maybe some can help me to find control which shows the graph but with
possibility to move points of the graph with mouse e.g, so the graph change
the position of the the point and return x,y of point moved.
Some links if possible on such products
You might want to look at www.infragistics.com and their NetAdvantage
product. They sell a class called UltraWinChart which is extremely dynamic
as to what you can do with it.
They support both VS2003 and VS2005.
"Arkady Frenkel" <firstname.lastname@example.org> wrote in message
news:u2PjWPQFGHA.2704@TK2MSFTN...How do I make a graph?
I need to make a graph with the Drug Concentration (mM) and the Percentage of
Growth. I don't know how to make it!
Assuming you already have the data, take a look here for info on Excel
If it's a specific type of graph, you'll have to tell us what you want.
"needhelp123" <email@example.com> wrote in message
>I need to make a graph with the Drug Concentration (mM) and the Percentage
> Growth. I don't know h...graph lines will are not visible, just the points
I can see the markers of my graph, but the line joining those markers are not
On Mon, 30 Jul 2007, in microsoft.public.excel.charting,
ben <firstname.lastname@example.org> said:
>I can see the markers of my graph, but the line joining those markers are not
Press F1 and search for a Help item called something like
"Change colors, patterns, lines, fills, and borders in charts"
NB Personal replies to this post will send email to email@example.com,
which goes to a spam folder-- please send your email to del3 instead.
Are there ga...Graph formatting
I would like to shade the area on a line graph between 10-80 different from
below 10 and above 80. How can this be accomplished?
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Mike Williams" <Mike Williams@discussions.microsoft.com> wrote in message
>I would like to shade the area on a line graph between 10-80 different from
> below 10 and above 80. How ...Deleting Source FIle after Integration
I have used the following VB Scripts to delete my source file after running
I opened the Integration>Scripts
I attached: SetVariable "error", 1 on the Document Error
I attached the below on the After Integration
If GetVariable ("error") = "" then
The Script Library that comes with Integration Manager includes many useful
scripts including how to delete the source file after a successful
integration. An added tidbit in the script library is:
If you want the user to se...Powerpoint 07
i have an issue with a number of our machines, when selecting the Chart from
the Insert Tab it brings up the 2003 menu rather then 2007 wizard.
Initial Screen -
What You Get -
What You Should Get -
i've check the machines not running in compatibility mode or anything like
that but i'm at a loss as to what's causing it.
Product is Office 2007 Enterprise with SP2 applied.
I think it's a registry s...selected index row color
The question is with a gridview. I have changed an asp:bound field with an
asp:templatefield using a linkbutton inside (source code is below). This is
the ID column that the user will see with it underline. They are
familiar/accustomed to seeing this and what it means and what they can do.
But, I also had the SELECT next to the row that when clicked the
SelectedIndexChanging event would turn the row as indicated in the
SelectedRowStyle of the gridview. The Select is gone in favor of adding real
estate back into the gridview.
<asp:TemplateField HeaderTex...Retaining Data Point Colors while Deleting a previously plotted Column?
I cannot determine how to keep the data point color associated with a
particular cell in a series from moving. The problem has only occured
as I began going past 12 months of data, under a 12 month rolling data
format. This is the first month that we have more than 12 months, so I
delete the Sept 02 column and add a Sept 03 column.
For some reason, Excel shifts all the previously defined data point
colors to the right by one data point (actually, the data point values
seem to move to the left one position (desired), while the colors stay
in place (undesired). If I could use absolute referen...Hyperlinkage of one graph with another graph or Drill down graph
There is need of hyperlink of two graphs. eg.
Graph 1:-Monthwise Equipment Downtime graph- Bar graph having Months on
X-axis and Downtime(Hrs) on Y-Axis.
we want to know the downtime of 10 equipment (EQ1, EQ2, EQ3, ----E12)
monthwise (say for 12 months).This graph can be made easily.
Graph 2:- Equipment failure by reason pie graph
Now we want to show the pie graph for the reason of downtimes for each
equipment (like say for EQ1:- 40%- Material failure, 30% Process failure,
30% Design failure)
Now we want to hyperlink graph 2 with graph 1 so that clicking on bar of
equipment will displa...INSERT/SELECT
Is the entire statement below a transaction, or is the select statement like
a derived table which is "materialized" before a transaction for the INSERT
INSERT INTO foo (x)
SELECT y FROM bar AS b
WHERE NOT EXISTS(SELECT * FROM foo WHERE x = b.y);
-- Thanks in advance
It's considered a transaction.
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
"KH" <KH@discussion...Selecting a CListCtrl dynamically (SetItemState)
Can anyone 'guess' why the following 2 lines don't select an item in my list
any more. It worked when I tested it a few months ago, but now it doesn't
do/select anything! There is no scroll bar (room for all items in my list)
and nothing is selected when I do these 2 lines:
SetItemState(rowToSelect, LVIS_SELECTED, TRUE);
The list is not the active window, but they should still appear selected (in
grey). Perhaps I have missed a setting to do with selections being visible?
My creation line for the lists is:
m_listCtrlSoftware.Create(W...Totals in 3d bar graph don't add up correctly
When I highlight a range of data to create a 3D bar graph with the Charts
Wizard and follow the steps, the resulting bars do not match up with the
original data. For example, I have five different fiscal years for my
company and their corresponding budget:
FY07 Actual FY08 FY09 FY10 FY11
$81,173.00 $260,244.20 $453,499.79 $576,582.05 $704,575.88
When I put these in a chart, the bars do not line up correctly (i.e. the
FY11 bar only reachs to just below the $700,000 line, rather than just above
And that is...Powerpoint Graph- Shading in between two linear graph lines
If I created a linear graph (in Powerpoint) with two lines: one showing
actual money spent and the other showing the budget over the course of a year
is it possible to shade the difference (or the region of space) between the
two lines. Basically indicated the sizable difference in actual money spent
Yes you can do this by adding 2 extra data series and plotting them as
Assuming your line data is currently in row 1 and 2 of the datasheet and
your data is plotted By Rows.
Copy row 2 to row 3
Copy row 1 to row 4
Now select the series in row 3 and change the...Charts and graphs
How can I create professional looking charts and graphs
to put in a Publisher document? Publisher itself has no
real tools and I don't know how to use Adobe Illustrator.
Hi Richard Dot-com (firstname.lastname@example.org),
in the Microsoft� newsgroups
|| How can I create professional looking charts and graphs
|| to put in a Publisher document? Publisher itself has no
|| real tools and I don't know how to use Adobe Illustrator.
Publisher can be used to create some awesome looking charts actually.
Probably some of the best charts out there. But Publisher c...node-sets not sent to xslt extension object correctly
Here's what I have (in snippets)
** XML **
** XSLT **
parent: <xsl:value-of select="util:LocalName(.)"/>
child: <xsl:value-of select="util:LocalName(child)"/>
grandchild: <xsl:value-of select="util:LocalName(child/grandchild)"/>
** C# (util object) **
public string LocalName(XmlPathNodeIterator xit)
but for some reason, each call t...Excel 2003 Graphing
Is it possible to add Text in the background of a graph in Excel 2003?
I know in MS word 2003 you can add Word Art and place the text behind
your normal text in the document.
Create the text in a graphics program and save it as a JPG.
In Excel double-click the Chart Area and choose Fill Effects on the Patterns
tab, Picture, Select Picture and find your graphics file. The Plot Area will
hide the text unless you double-click it and on the Patterns tab choose None
You can put the picture into the Plot Area instead by proceeding as above
with the plot area.
Cheers...How can I set up highlighting ON the graph?
I have a bunch of different line graphs showing different plots.
What I want to do, is be able to use a min and max on the Y axis that will
create an area through which the plots go through.
However, I want this area to be highlighted in some way to show that the
points in this highlighted part are acceptable, and the others are outside
I don't want to manually change the limits of the graph because I want the
outside points showing.
Not sure how else to explain it.
Is this even possible in Excel? Any help would be appreciated.
You could use an extra data...Data Validation of multiple sources
I am currently using Excel XP. I would like to do a
multiple concurrent data validation of data. I have an
example which uses data validation using a Continent
selection, then a Country selection based on continent,
and then a State selection based on country. There is a
data sheet attached to the example and it looks like it
has a matrix with every possible senario listed. I was
wanting to create a similar Data Validation using numeric
data but have been uncussesful in doing so. Does anyone
have a procedure I could follow for this type of data
validation based on many sources?
how do you add quadrant lines to a graph?
These are possibilities:
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
"CAMG" <CAMG@discussions.microsoft.com> wrote in message
> how do you add quadrant lines to a graph?
...Sub select in LINQ
I'm trying to write a sub select in linq to generete the list of
I have an XML like this:
<?xml version="1.0" encoding="utf-8"?>
<User id="1" loginId="arun" firstName="Arunkumar"
<User id="2" loginId="arun" firstName="Arunkumar"
<assignedRoles>...Date Criteria Correct?
Access 2000. I need to keep track of point totals for sick time for
employees for the last 12 weeks. I have my totals query totaling up
correctly. The glitch is, each employees time starts on the first date they
call in. Is this criteria below going to return the last 12 weeks from
today or the last 12 weeks for each employee?
Try it in Immediate Window and see --- It'll give you the date that is 12
weeks ago today. It will not be dependent upon an employee's "first date [he
I have a graph in excel and I am required to find the
area below the line of the graph. Usually I would add a
trendline and the integrate the function to find the
area, however the graph is fairly complex and I was
wondering if there was a magic tool within excel that
will do this for me.
the cubic spline based code posted by David Braden
the Trapezoid or Simpsons 1/3 rule documented by Bernard Liengme at
Might also be worthwhile to check...