Powerpoint Chart Error
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Mon, 24 Oct 2016 11:35:02 GMT by s_wx1126 (squid/3.5.20)
up/down bars to a chart Applies To: Word for Mac 2011, Excel for Mac 2011, PowerPoint for Mac 2011, Less Applies To: Word for Mac 2011 , Excel for Mac 2011 , PowerPoint for Mac 2011 , More... Which version do I have? More... Which Office program are you using? Word PowerPoint Excel Word Error how to add error bars in excel 2010 bars express potential error amounts that are graphically relative to each data point or data marker in
Excel 2016 Error Bars
a data series. For example, you could show 5 percent positive and negative potential error amounts in the results of a scientific experiment. You can add the chart data grid is already open error bars to data series in a 2-D area, bar, column, line, stock, xy (scatter), or bubble chart. For xy (scatter) and bubble charts, you can display error bars for the x values, the y values, or both. Do any of the following: http://answers.microsoft.com/en-us/msoffice/forum/msoffice_powerpoint-mso_mac/error-when-editing-charts-to-insert-a-chart-you/82f80504-14d8-4e92-907c-ddf20faddaf0 Express errors as a percentage, standard deviation, or standard error On the View menu, click Print Layout. In the chart, select the data series that you want to add error bars to, and then click the Chart Layout tab. For example, in a line chart, click one of the lines in the chart, and all the data marker of that data series become selected. Under Analysis, click Error Bars. Do one of the following: Click To Error Bars with Standard Error Apply the standard error, using https://support.office.com/en-us/article/Add-error-bars-or-up-down-bars-to-a-chart-93452c4a-442e-4ee6-b4ec-ff32bfca8d7f the following formula: s = series number I = point number in series s m = number of series for point y in chart n = number of points in each series y is = data value of series s and the I th point n y = total number of data values in all series Error Bars with Percentage Apply a percentage of the value for each data point in the data series Error Bars with Standard Deviation Apply a multiple of the standard deviation, using the following formula: s = series number I = point number in series s m = number of series for point y in chart n = number of points in each series y is = data value of series s and the I th point n y = total number of data values in all series M = arithmetic mean Express errors as custom values On the View menu, click Print Layout. In the chart, select the data series that you want to add error bars to, and then click the Chart Layout tab. For example, in a line chart, click one of the lines in the chart, and all the data marker of that data series become selected. Under Analysis, click Error Bars, and then click Error Bars Options. If you see the Add Error Bars dialog box, select the series that you want to add error bars to. In the navigation pane, click Error Bars. Under Error amount, click Custom, and then click Specify Value. Switch to Exc
class and I'm working through my existing materials for Office 2003 using Office 2007 to see what changes I'm going to have to make. I'm http://www.tech-archive.net/Archive/Office/microsoft.public.powerpoint/2010-08/msg00030.html using PowerPoint 2007. I've created a presentation which currently has two slides. The second slide is Title and Contents. When I click on the button to insert a chart, I select Column http://gethelp.library.upenn.edu/workshops/biomed/ppt/graphs.html Chart then OK. I get the following error message "To insert a chart, you must first close any open dialog boxes or cancel editing mode in Microsoft Office Excel." then "Some error bars chart types cannot be combined with other chart types. Select a different chart type." Excel is not open. I even restarted the computer to clear out the cobwebs just in case my having opened Excel 2007 earlier was the cause of the problems, but that didn't help. There are no dialog boxes open. I'm not trying to combine any types of charts. I error bars excel just want to create a simple column chart by typing in data. (I have both Office 2003 and Office 2007 running on this computer, a Toshiba tablet running WinXP Pro.) I was thinking how handy it is to be able to choose one slide type then click a button for the type of content, rather than having to choose among several slide types, depending on what content you want to include, but I'm not thrilled at this error that I can't seem to get around. I must be doing something stupid and I just don't realize it. Thanks, liz On Tuesday, October 02, 2007 9:48 PM Echo S wrote: Oh, man. I have a vague recollection of this from the beta, but I can't for the life of me remember what the issue was. Try opening Excel before clicking the icon. I know that's counterintuitive, but give it a shot. Also, what if you use Insert | Chart? Do you get the message then? What if you open Excel before Insert | Chart? -- Echo [MS PPT MVP] http://www.echosvoice.com What's new in PPT 2007? http://www.echosvoice.com/2007.htm Fixing PowerPoint Ann
design Customizing background Applying and creating templates Design tips Working with graphics Downloading, inserting and editing images Image Resources for Health & Life Sciences Drawing and editing objects Working with animation Animating text and images Slide transitions Adding sound and video Sounds, narration and music Video requirements Graphs and tables Working with graphs Importing and linking data from Excel to PowerPoint PowerPoint online Hyperlinks and action buttons Putting up a presentation on the web Printing and Presenting Printing options Running a slide show Links PowerPoint DO's and DON'T's Other PowerPoint websites Workshop evaluation (for on-site workshop participants only) Working with Graphs You can insert a graph by selecting Insert Menu < Chart. A new window opens showing a dummy spreadsheet, a graph based on that dummy data, and chart menu and toolbar options become activated. Experiment with the data sheet by clicking on a cell and typing your own data, to understand the effect of the data changes on the chart. After you've finished entering data, exit the work window by clicking anywhere outside the chart or the data sheet. The data sheet will disappear. If you need to make any revisions to the chart, double-click the chart and the data sheet will appear again. PowerPoint defaults to bar graph. You can select another type of chart through the Chart menu < Chart Type. Note: the Chart and Data menus are active only when the chart is selected and the data sheet window is open. Double-click on the chart to open the data sheet and activate the chart menu. You can change the chart options, such as titles, axes, gridlines, etc., by selecting Chart menu < Chart Options. You can also change the chart area colors and fill effects by clicking on the outer or inner chart area respectively: If you click in the middle of a bar/column/line, a little square handle will appear to let you know that you have selected a data series: Right click on the square handle or se