Where is graph on excel

Excel displays recommended charts based on the data in the cells selected. You can hover over each one to see what looks good for your data. And now, I have an eye catching chart of the data. It looks like the Summer months are slower and the Winter months are busier. Up next, Create pie, bar, and line charts. Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. 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. The Insert Chart dialog box appears, displaying every chart type that is available. The chart appears in the worksheet and the Chart Tools appear on the Ribbon. The Chart Tools include three new tabs—Design, Layout and Format—that help you modify and format the chart.

To help make your decision easier, Excel offers Recommended Charts. This tool looks at the data you have selected and suggests a few charts that will represent it well. Toggle navigation. Free Excel Training.

Chart Types in Excel Column Column charts are used when you want to compare different values vertically side-by-side.

Each value is represented in the chart by a vertical bar. If there are several series, each series is represented by a different color. Now click on Format Legend to fine-tune your choices. Related: How to unhide columns in Microsoft Excel. You can pick up a few best-seller courses that combine Excel with basic business skills and give your resume a boost.