Excel Graph Help

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

ayush

Thread Starter
Joined
Mar 27, 2005
Messages
86


In the above graph there is a line on graph which indicates mean value. Will any one explain me with an example(how to write values, mean value and which chart format I have to choose etc) on how to make a graph like this. I am using excel 2007.

Thanks in advance
 
Joined
Oct 20, 2004
Messages
7,837
Do you mean a mean luminance between the three groups (HID1, HID2 and HLB)?
 

ayush

Thread Starter
Joined
Mar 27, 2005
Messages
86
Desr slurpee55,

Above chart is just for reference to show the single line on the graph bar. (on dog bar a line is ending at approximately at 2.4 and started at 0.6) Like this I want draw a chart.
 
Joined
Oct 20, 2004
Messages
7,837
Bars like those are usually range markers - the highest and lowest points in the data being marked by the, in this case, 2.4 and .6. If you want to show those, click on a column in your graph, go to Format Data Series, Go to the Y Error Bars tab and click Both. If you make it a percentage and set that value to 50, it will show you a bar going down and stopping at the 50% and going up and stopping 50% above the data column.
I just find it easier, however, to calculate the mean next to the original data and include that column of data in the graph also.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top