$$Excel-Macros$$ Re: plot mean and variance

2009-06-13 Thread Fabio Lemos
I have used a line chart (becouse of the x category axis, eg.: tn, t12, t18...). Then I have selected the data series and added the error bars (menu Layout >> Error bars) with an custom ammount. 2009/6/12 jenny Hanson > Hello Fabio, > > I need to plot the two on the graph (mean and variance) si

$$Excel-Macros$$ Re: plot mean and variance

2009-06-12 Thread jenny Hanson
Hi Fabio, I'm using the Excel 2007 version -insert -...graphics... I do know the type of graphic why you make, but i need to make with mean and variance in same graphic regards Jen 2009/6/12 Fabio Lemos > You will need to add error bars with custom values... > > see attached f

$$Excel-Macros$$ Re: plot mean and variance

2009-06-12 Thread Fabio Lemos
You will need to add error bars with custom values... see attached file... If you need help, please inform wich excel version do you use... 2009/6/12 jen > > Dear member, > I have a question . The question is how > to make a graph….I do know your name or kind > For example I have range th

$$Excel-Macros$$ Re: plot mean and variance

2009-06-12 Thread Amitabh Bose
Hi Jen, I have attached a file with the points plotted for both the mean and variance. I am not sure which version of MS Excel you are using. The version of the file attached is on MS Excel 2007 and the steps to construct the graph is as follows: 1. Insert - Choose chart type (Eg column