how to create a bar graph in excel 2011 for mac

Create A Bar Graph In Excel 2011 Software For Mac
Create A Bar Graph In Excel 2011 For Free By Whitelisting

Add data directly into the attached text boxes and the shapes (bar, column, pie and line etc.) will change automatically.

Create A Bar Graph In Excel 2011 Software For Mac

See how to do it with our amazing chart and graph software for Mac easily in the following tutorial.

When moving a shape, the dynamic guidelines show to help you align it with the nearby shapes.

After you enter new numbers in the data labels, relevant shapes will change automatically to reflect the data changes.

Customize the size, color and alignment by clicking relevant menus.

Adding your company logo to the background and using this background as master template are also a good way to promote your business.

This may be for viewing online within a webpage; for inclusion in another application, such as PowerPoint; or just for printing.

EdrawMax is an advanced all-in-one diagramming tool for creating professional flowcharts, org charts, mind maps, network diagrams, UML diagrams, floor plans, electrical diagrams, science illustrations, and more.

You can create a graph from data in both the Windows and the Mac versions of Microsoft Excel.

There are three basic types of graph that you can create in Excel, each of which works best for certain types of data: 1.

Best for listing differences in data over time or comparing two similar sets of data.

The headers, which determine the labels for individual sections of data, should go in the top row of the spreadsheet, starting with cell B1 and moving right from there.

The labels that separate rows of data go in the A column (starting in cell A2 ).

Things like time (e.g., Day 1, Day 2, etc.) are usually used as labels.

Starting in the cell immediately below your first header and immediately to the right of your first label (most likely B2 ), enter the numbers that you want to use for your graph.

In the Charts section of the Insert toolbar, click the visual representation of the type of graph that you want to use.

In your selected graphs drop-down menu, click a version of the graph (e.g., 3D ) that you want to use in your Excel document.

Double-click the Chart Title text at the top of the chart, then delete the Chart Title text, replace it with your own, and click a blank space on the graph.

If this doesnt work, double click the axis and use the dots to move it.

In the Select Data Source dialog box, under Legend Entries (Series), select the data series, and click Edit.

On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click Vertical (Value) Axis.

Keep in mind, Column A is used for your horizontal axis information.

B1, C1, D1 etc. can be used as headings for each vertical axis.

Just make sure any information you input into these columns correlate cell by cell with your column A horizontal axis information.

The information inputted in these columns i.e.

B, C, D, E, etc. will be converted into a bar in your bar graph when you select all your information, click insert, then chart and choose bar graph.

Its important to choose a graph format that works with your data.

Enter the graphs headers.

Add the graphs labels.

Enter the graphs data.

Click Insert. 6. Select a graph type.

Select a graph format.

Add a title to the graph.

By continuing to use our site, you agree to our cookie policy.

Create A Bar Graph In Excel 2011 For Free By Whitelisting

Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker.

If you really cant stand to see another ad again, then please consider supporting our work with a contribution to wikiHow.

How To Create A Bar Graph In Excel 2011 For Mac