- #HOW TO USE MICROSOFT OFFICE TO CREATE BAR GRAPHS HOW TO#
- #HOW TO USE MICROSOFT OFFICE TO CREATE BAR GRAPHS UPDATE#
Once you’ve inserted a histogram into your Microsoft Excel worksheet, you can make changes to it by right-clicking your chart axis labels and pressing the “Format Axis” option.Įxcel will attempt to determine the bins (groupings) to use for your chart, but you might need to change this yourself.
#HOW TO USE MICROSOFT OFFICE TO CREATE BAR GRAPHS HOW TO#
Excel will attempt to determine how to format your chart automatically, but you might need to make changes manually after the chart is inserted. This will insert a histogram chart into your Excel spreadsheet. In the “Histogram” section of the drop-down menu, tap the first chart option on the left. The various chart options available to you will be listed under the “Charts” section in the middle.Ĭlick the “Insert Statistic Chart” button to view a list of available charts. The Excel worksheet is a separate file and is not saved with the PowerPoint file.With your data selected, choose the “Insert” tab on the ribbon bar. If you want to change the data in the chart, you must make your changes to the linked worksheet in Office Excel 2007 and then refresh the data in your PowerPoint presentation. When you copy a chart from a saved Office Excel 2007 file and paste it into your presentation, the data in the chart is linked to that Excel file.
You can paste an Excel chart or graph into your presentation and link to the data in an Office Excel 2007 file. When you create a new chart in PowerPoint 2007, you edit the data for that chart in Office Excel 2007, but the data is saved with the PowerPoint file. You can create a chart or graph in your presentation. You can add a data chart or graph to your presentation in one of two ways: Top of page Overview of data charting and graphing To learn about the different types of Excel charts that you can add to your PowerPoint slides, see the article Available chart types. To create a timeline using a SmartArt graphic, see the article Create a SmartArt graphic. To create an organization chart, see the article Create an organization chart.
Top of page Create an organization chart, a timeline, or add a chart from Excel On the Home tab, in the Clipboard group, click the arrow under Paste, and then click Paste. In PowerPoint 2007, click the placeholder on the slide or notes page that you want to insert the chart on. In Excel, select the chart by clicking its border, and then on the Home tab, in the Clipboard group, click Cut.
#HOW TO USE MICROSOFT OFFICE TO CREATE BAR GRAPHS UPDATE#
Note: If you want to be able to automatically update or refresh the data in your chart or graph, you must save the Excel file before inserting the chart or graph. Some types of charts, such as organization charts, flow charts, hierarchical diagrams, or showing repetitive information, might be more easily and effectively created using SmartArt.įor more information about how to insert a linked Excel chart, see Insert a linked Excel chart in PowerPoint 2010.įor more information about how to edit data in a chart, see Edit data in a chart. You can also access design, layout, and formatting features that are available for specific chart elements (such as chart axes or the legend) by right-clicking those chart elements. To get a good idea of what you can add to or change in your chart, under Chart Tools, click the Design, Layout, and Format tabs, and then explore the groups and options that are provided on each tab. For more details, see Change the data in an existing chart. Click the chart, then on the green Chart Tools tab, select the Design tab, and then click Edit Data. Note: If you don't see the Chart Tools, make sure that you click anywhere inside the chart to activate it.