How to create tables and graphs in excel

how to create tables and graphs in excel

Excel Charting Basics: How to Make a Chart and Graph

Create a table with the data. Select the range of values A1:B5 that need to be presented as a chart. Go to the «INSERT» tab and choose the type. Click «Insert Column Chart» (as an example; you may choose a different type). Create a chart. You can create a chart for your data in Excel for the web. Depending on the data you have, you can create a column, line, pie, bar, area, scatter, or radar chart. Click anywhere in the data for which you want to create a chart. To plot specific data into a chart, you can also select the data.

Create and format a table to visually group and analyze data. Note: Excel tables shouldn't be confused with the data tables that are part of a suite of What-If Analysis commands Data Toolson the Data tab. See Introduction to What-If Analysis for more information.

In the Format as Table dialog box, set your cell range. Insert a table in your spreadsheet. See Overview of Excel tables for more information. To rename a default header, double-click it and type a new name. Overview of Excel tables. Video: Create and format an Excel table.

Total the data in an Excel table. Format an Excel table. Resize a table by adding or removing rows and columns.

Filter data in a range or table. Convert a table to a range. Using structured references with Excel tables. Excel table compatibility issues. Export an Excel table to SharePoint. Next: Charts. Select a cell within your data. Choose a style for your table. Mark how to redirect my domain name to another website your table has headers.

Select OK. To format existing data as a table by using the default table style, do this: Select the cells containing the data. A subscription to make the most of your time. Try one month free. Need more help? Expand your Office skills.

Get instant Excel help. Was this information helpful? Yes No. Any how to create tables and graphs in excel feedback? The more you tell us, the more we can help. How can we improve? Send No thanks. Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents. Contact Support.

Was this information helpful?

Mar 26,  · Select a graph format. In your selected graph's drop-down menu, click a version of the graph (e.g., 3D) that you want to use in your Excel document. The graph will be created in your document. You can also hover over a format to see a preview of Estimated Reading Time: 6 mins. Jan 22,  · Although graphs and charts are distinct, Excel groups all graphs under the charts categories listed in the previous sections. To create a graph or another chart type, follow the steps below and select the appropriate graph type. Select Range to Create a Graph from Workbook Data. Select a cell within your data. Select Home > Format as Table. Choose a style for your table. In the Format as Table dialog box, set your cell range.

This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness. The wikiHow Tech Team also followed the article's instructions and verified that they work. This article has been viewed 1,, times. Learn more This wikiHow teaches you how to create a graph or chart in Microsoft Excel.

You can create a graph from data in both the Windows and the Mac versions of Microsoft Excel. Select all data including headers and labels. Click Insert. Select a graph type. Select a graph format. Add a title to the graph. Did this summary help you? Yes No. Log in Social login does not work in incognito and private browsers.

Please log in with your username or email to continue. No account yet? Create an account. Edit this Article. We use cookies to make wikiHow great. By using our site, you agree to our cookie policy. Cookie Settings. Learn why people trust wikiHow. Download Article Explore this Article Steps. Tips and Warnings.

Related Articles. Article Summary. Open Microsoft Excel. Its app icon resembles a green box with a white "X" on it.

Click Blank workbook. It's a white box in the upper-left side of the window. Consider the type of graph you want to make. There are three basic types of graph that you can create in Excel, each of which works best for certain types of data: [1] X Research source Bar - Displays one or more sets of data using vertical bars. Best for listing differences in data over time or comparing two similar sets of data.

Line - Displays one or more sets of data using horizontal lines. Best for showing growth or decline in data over time. Pie - Displays one set of data as fractions of a whole. Best for showing a visual distribution of data. Add your graph's headers. 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.

Add your graph's labels. The labels that separate rows of data go in the A column starting in cell A2. Things like time e. For example, if you're comparing your budget with your friend's budget in a bar graph, you might label each column by week or month.

You should add a label for each row of data. Enter your graph's data. 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.

Select your data. Click and drag your mouse from the top-left corner of the data group e. Click the Insert tab. It's near the top of the Excel window. Doing so will open a toolbar below the Insert tab. In the "Charts" section of the Insert toolbar, click the visual representation of the type of graph that you want to use. A drop-down menu with different options will appear. A bar graph resembles a series of vertical bars.

A line graph resembles two or more squiggly lines. A pie graph resembles a sectioned-off circle. In your selected graph's drop-down menu, click a version of the graph e.

The graph will be created in your document. You can also hover over a format to see a preview of what it will look like when using your data. 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. On a Mac, you'll instead click the Design tab, click Add Chart Element , select Chart Title , click a location, and type in the graph's title.

Save your document. To do so: Windows - Click File , click Save As , double-click This PC , click a save location on the left side of the window, type the document's name into the "File name" text box, and click Save. Mac - Click File , click Save As Click "Edit" and then press "Move.

Not Helpful 20 Helpful 8. Type control p on your laptop or go to print on the page font of your screen? Not Helpful 0 Helpful 6. Jayna Akanova. Right-click the chart with the data series you want to rename, and click Select Data. In the Series name box, type the name you want to use. Not Helpful 3 Helpful 1. Not Helpful 1 Helpful 1. In a chart, click the value axis that you want to change, or do the following to select the axis from a list of chart elements: Click anywhere in the chart.

Deborah Archary. Assuming you already know how to make a basic bar graph from a workbook? If not, check out Wikihow's article "Create a Graph in Excel. B1, C1, D1 etc. Input information from cell 2 onwards in each column. 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. B, C, D, E, etc.

Tina X. To change a data series, you would select a range of your spreadsheet appropriate for the data. Not Helpful 0 Helpful 0. Include your email address to get a message when this question is answered. You can change the graph's visual appearance on the Design tab. Helpful 1 Not Helpful 0.

If you don't want to select a specific type of graph, you can click Recommended Charts and then select a graph from Excel's recommendation window. Helpful 0 Not Helpful 0. Submit a Tip All tip submissions are carefully reviewed before being published. Some graph formats won't include all of your data, or will display it in a confusing manner.

It's important to choose a graph format that works with your data. Helpful 3 Not Helpful 1. Related wikiHows How to. How to. About This Article. Co-authored by:. Co-authors:

4 Replies to “How to create tables and graphs in excel”

  1. Thank you for all your tips I been using them on my videos and getting better at editing. Love your videos

Add a comment

Your email will not be published. Required fields are marked*