I would like to create a histogram from experimental data with the normal distribution curve overlaying the histogram.

Ther doesn't seem to be a clear way to do this. Any suggestions?

Ther doesn't seem to be a clear way to do this. Any suggestions?

- Normal Distribution Curve Overlay
- Normal Curve overlay bar graph
- How do I make a Normal Curve with my data
- How to plot a normal distribution curve!!!!!
- Plotting a normal distribution and a column chart
- Discrete "Normal" Curve Function?
- Frequency chart and normal curve
- Normal Curve Issue
- Scatter plot with two data series having common x-values
- Scatter plot with multiple Y-values and same X value.
- Difficulty placing active email / hyperlinks with normal text in c
- How do i plot a logistic curve?
- Secondary X-axis with reverse Y-axis
- Scatter plots with multiple series
- Plotting with 3 columns data (X,Y and Values)
- XY Chart with many curves: Independent legend entries?
- Histogram Plot
- Plot with dropdown menu
- Plot a bell curve
- Showing a specific value against a normal curve
- HOW WE CAN CREATE THIRD AXIS IN AN GRAPH WITH 3 CURVES
- How to do a scatter plot with a 3-D visual effect?
- In excel scatter plot with 2 series, how do I connect xy coordinat
- Plot the sin curve along the line y=x

Bubble size range No of bubbles

9.5-10.0mm 2

10.1 -10.5mm 7

10.6-11.0mm 3

11.1- 11.5mm 9

11.6-12.0mm 7

12.1-12.5mm 7

12.6-13.0mm 2

13.1-13.5mm 11

Thanks!

I have a normal, basic distribution bar graph. I learned how to SEPARETELY graph a normal bell curve. I want to OVERLAY this bell curve on my original bar graph, so i can compare our sample to the norm. Any easy way to do this?

Eddie Policastro

to work out what the y values are for each part in x

or, more explicitly

For a given integer total N, then given a two tailed normal (Gaussian), I

want to know the function values at M equally spaced points along the x axis

this isn't some kind of homework cheat, I'm messing with an NFL stats

program for a tabletop sim game. I wanted the countif stuff to see what kind

of %age of a teams total running attempts were made by each back

Now, I have a set of endurance ranges, either 5 or 6, not sure yet, and want

the number in each group to then reflect a normal Gaussian distribution with

the bulk of players in the middle category and very few at each end

I can remember 1 std dev either side containing ~ 66% of the population and

doesn't 2 std dev cover ~ 95%?

something else is coming back to me - isn't this z-scores, with the mean at

"x=0" effectively where the normal is centred around?

anyway I know the mean and stdev of the values, so hopefully there is a way

to quickly calculate the bounding limits of any arbitrary (equal) set of

divisions of the population

1. I have a series of about 200 numbers that I would like to create a

frequency chart/graph for. I am having difficulty in OL2000 creating a

frequency graph.

2. I have the mean and standard deviation. I do I create a normal curve

with this data?

Thank you,

Carl

x-values? When I go to Select Data Source and Add a series, I have to

specify both x-values and y-values. If I add a second data series with the

same x-values as the first, then the x-axis labels are just 0,1,2,..., not

the x-values I specified. I do get a scatter plot with two data series, but

the x-axis is not correctly labelled.

This was no problem in prior versions of Excel, but like everything else in

the "easier to use" Office 2007, it is much harder to figure out.

http://imageshack.us/photo/my-images...0618at353.png/

I am finding great trouble placing web & email addresses in cells along with

normal text and have wasted a lot of time trying to sort this out. Either all

the text is in normal font (& acting like a link) or all the text is actively

highlighted as a link!

How do I easily control this so I can have both normal text & links (but

seperately/alongside each other) within cells?

The auto complete function to typing web/email links is turned on but it

doesn't appear to make any difference!

How to I format the cells to achieve what I want? It seems to me the cell

format must not be allowing this function to happen, but I have tried

reformatting the cells without success! Frustratingly I have some cells in my

worksheet where links & text do coexist!

I have searched for help on the net with no success either yet.

I am most grateful for help & advice to help me & look forward to all

replies.

Thanks

Richard

--

RPD

(0,38558),(10,49371),(20,62980),(30,76212),(40,922 28),(50,106022),(60,123203),(70,132165),(80,151326 ),(90,179323),(100,203212),(110,226546),(120,24871 0),(130,281422)

data

x1 y2 x2 y2 x3 y3

2.7 9.4 30.7 100.1 1.275 9.4

5.6 25.5 33.6 90.7 1.325 25.5

8.0 39.4 39.3 74.6 1.375 39.4

10.1 51.1 45.5 60.7 1.425 51.1

Plotting.

Set data 1 ( x1,y1 ) = plot with reverse Y value

Set data 2 ( x2,y2 ) = plot with normal Y value

Set data 3 ( x3,y3) = plot with reverse Y value, need secondary axis

I have been succesfull to plot all the data, except when i have to use the

secondry X-axes ( set data 3 )

i know there has been suggestion about " go to chart option and change it to

secondary x-axis, but the problem is because i have revese the Y value, the X

- axis swap to the top make it unable to have secondary axis

what happen when i " tick" secondary axis, my primary X-axis will

dissapear........please help me excel expert..........

the x setting are time. I am wondering if there is a way with in excel to

select the columns and then plot them accordingly

Thanks

--

Kat

I have the following data, which I want to plot with Excel chart:

x y value

1 1 0.191850392857143

1 2 0.343870875

1 3 0.373216464285714

1 4 0.439175392857143

2 1 0.0218835357142857

2 2 0.136193589285714

2 3 0.146259946428571

2 4 0.181633303571429

..... can be more ....

How can I plot the data (scatter) where the x-axis correspond

to "x" and y-axis correspond to "y".

Regards,

Gundala Viswanath

Jakarta-Indonesia

I have to generate an XY Chart (a full sheet) out of transistor

parameterized data. (The parameter is the voltage applied to the base,

and X and Y refer to Collector current and Collector-Emitter-Voltage,

respectively. But this shouldn't matter). The data is on another sheet

and it looks like that:

Trans1 Trans2

Param1 Param2 .... Param10 Param1 Param2...

X Y X Y X Y X Y...

The curves appear as follows:

Different symbols for different parameters

Different colors for different Transistors.

That is, the X-Y-Curve of Trans1-Param1 is drawn with red crosses (for

instance). the X-Y-Curve of Trans1-Param2 is drawn with read circles.

The X-Y-Curve of Trans2-Param1 draws with blew crosses, and

Trans2-Param2 draws with blew circles, and so on, up to

Trans5-Param10.

I have found the legend to be strongly coupled with the curves, but I

would have a different legend.

Instead of having legens entries Trans1_Param1, Trans1_Param2,

....Trans6_Param10, i.e. all combinations, I just would like to have

this legend:

+++ Param1 ----- Trans1

ooo Param2 ----- Trans2

....

----- Trans6

@@ Param10

That is, the Param legend entries should appear with their

corresponding symbols, but in black. The TransX legend entries should

appear as lines in their corresponding colors.

Is there a way to perform this in Excel VBA? I mean, this is probably

the legend humans want for parameterized data, especially if they are

used to Matlab, Diadem, and so on

Any help would be great.

Best regards

Johannes

When trying to do a histogram plot I receive the following error

message: "Cannot change part of a merged cell" and then "Histogram -

Cannot draw chart for empty bins"

I am using the Analysis ToolPak Add-In --> Histogram to Output a Graph

in a new worksheet.

As far as I can see, I do not have any merged cells in the ranges I

have selected.

Has anyone else encountered this error message? Is there something

simple I'm not seeing?

Any help is appreciated.

Thank you!

Nikki

I have two sheets tracking two key performance indices of people over time

what I need is a drop down menue where by selecting the person name it would display the plot with the two performance trends taken from the two tables, and the title of the plot would be the person name while the legend would point each performance index trend.

as an example i attached a sheet with similar simplified tables (can't put the real data) . here is a screen shot as well.

chart.jpg

Please any quick help would be appreciated

Google search but still confuse.

Thanks for advice.

Excel 2007.

curve. I would like to be able to show where, for example, a particular test

score would fall on the curve of all test scores. Suggestions please?

(Scatter Charts)") but with a 3-D visual effect like can be done in "3-D

Line" under Line charts.

this would allow a user to create something like a 3-d model of any object.

they allow the option for line charts, and i don't see the same thing for

scatter charts. seems like it would be very helpful, especially for what i

am doing, but for lots of other people too. any suggestions?

dan

is arranged in 4 columns, Series1-x-values, Series1-y-values,

Series2-x-values and Series2-y-values. I would like to draw a line between

the Series 1 and Series 2 xy-coordinate for each row in my data. Does anyone

have good tips on doing this? I would appreciate any help.

Thanks,

Anne

sin curve rotated by 45 degrees. I started by plotting points for the

equation y = x + sin(x). This resulted in a skewing of

the curve. I want the sin curve to be determined by the distance traveled

along and symmetrical around the line y = x.