Report this resource to let us know if it violates our terms and conditions. Contains a worksheet at the back for the class. Finally, apply the formatting to the other columns by highlighting the cells containing the upper and lower error bounds, and dragging the blue square on the bottom right of the box across the rest of your data columns. A very brief and simple introduction to shading for all ages. Copy the formula down as far as required. Code: min (a1,b1) where your first data series begins in a1, and your second in b1. If you want to shade the area below two intersecting lines, the formula could be as simple as. In this example, I subtracted the standard error (cell c4) from the average (cell C2).įind the upper and lower error bound for every time series in your data. Then add this series to the chart, and change the chart type for that series to AREA. Similarly, subtract the error from the average to find the lower bound.
So in our example, I added the average (cell C2) and the standard error (cell c4). Under Table Tools, on the Design tab, in the Draw Borders group: 2. To do that, select table or any (several) cells in the table and follow the next steps: 1. To find the upper bound of an error band, simply add the error to the average. In MS PowerPoint, you just need two simple steps: 1. STEP 2: FIND THE UPPER AND LOWER BOUNDS OF EACH ERROR BAND In the example above, I use standard error but you could also use a confidence interval, standard deviation, variance, or any other measurement of uncertainty.īelow the rows containing the averages and standard deviations, we will add additional rows for the upper and lower bound of each error band. Upon click, it will insert shaded region, now you can insert text in it. Regards, Bob J.The rows should contain the averages and uncertainty measurements associated with each condition and the columns should contain measurements over time. Place insert cursor where you need to insert colored region and head over to Home tab, from Paragraph group, under shaded color palette, select one. Select both &įor more on the use of Word 2008 drawing tools see Word Help on the topics associated with:ĪI: Artificial Intelligence or Automated Idiocy? Please mark Yes/No as to whether a Reply answers your question. Fill each as you prefer, thenĪlign them or overlap them to get the appearance you want.
Open the Color list for Fill & choose Fill Effects then click the Right-click the shape & selectįormat AutoShape. You may be able to get the effect you want by using a 2 color Gradient Fill.
Your explanation of what you want to do isn't very specific, so I can only offer some general suggestions: In order to sell more product.] Although they are reasonably good at what they do, they have their limitations. [And from a more jaded perspective :-) concessionary gimmicks added The graphics tools it provides are accessories included for convenience. The simple truth is that you most likely cannot :-) Word is a word processing program, not a graphic design app.
0 kommentar(er)
