Create A Line Chart In Excel For Mac

This post is brought to you by Jeffrey Johnson, a Program Manager on the Office Graphics and Visualizations team. Have you ever had a dataset but only needed to chart certain parts of it? Here are 4 methods for filtering your chart so you don’t have to edit or remove your data to get the perfect chart: hide data on the grid, table filtering, filtering using table slicers, and filtering directly from the chart. Setting up the chart We’ll begin by charting a dataset. Let’s say we’re running a produce stand at a farmers market and want to understand our cost and profit on our sales. To create the chart, select the range, then click the Quick Analysis tool.

How to search a web page for a word on mac. Use the Web browser to save the Web page as a file on your computer and then open the saved file in Word. For example, say you’re using a Web browser and you find a Web page that you want to edit in Word. Here’s how: • In the Web browser, choose File→Save As.

Now select Charts, and then click Clustered Column. This gives us the following chart.

Note: For this example, I added the chart title Produce Sales. You can add your own title by clicking on the chart title, which will allow you to edit the text. Hide data on the grid Now I want to completely remove Cost/lb from this chart to focus completely on the profit.

I can hide the entire column and it will be reflected in the chart. To hide the coulmn, right-click the column header containing Cost/lb and then select Hide.

This is a brief tutorial of creating a line chart using Historical Stock Price data for GM. Create and Format a Line Graph in Excel in 5 Steps When you just need a line, there are simple tips to use. Share Pin Email Print Software. Spreadsheets Documents. When you create a chart or graph in Excel or click on an existing graph, two tabs are added to the ribbon as shown in the image above.

The chart removes the series. Notice the grid header hints the hidden column.

If you want to show the cost data again, unhide the column. To do this, select both columns C and E by clicking the C column header and dragging it to column E. Now right-click the highlighted columns, and then click Unhide. Note: You also can also unhide by holding left-click on the right edge of the hidden column header and dragging it to the right. The series is now visible and on the chart once again.

Table filtering If you want to filter out specific foods from your chart, you can turn your grid data into a table, which provides filtering for each row. Select your data range, and then click the Quick Analysis tool. Select Tables, then click Table. Tables allow you to easily format, sort, filter, add totals, and use formulas with your data. Now that we have a table, we’ll filter the out-of-season produce.

To reveal the filter, click the down arrow next to Food. Uncheck the out-of-season items, then click OK. The filter is applied to the chart.

Try exploring more filtering options by trying different combinations of filters, and be sure to give the search bar a try. This would be extremely useful if we had the whole produce section in our table. Filtering using table slicers Table slicers create a filtering experience with buttons as part of your worksheet. This allows you to easily click through your data to visualize different segments. For more information, that dives into the details of table slicers. In this example, we’ll create a table slicer to compare specific produce costs and profits.