If you are looking for a simple and intuitively clear way to visualize large and complex data, a line graph is the right choice. Show relationships between multiple data sets. A multiple line graph can help you reveal relationships between two or more variables. When not to use a line graph There are a few cases in which a line graph is not suitable: Not suited for large data sets. Line graphs are best to be used for small data sets under 50 values. More values would make your chart more difficult to read. Best for continuous data. If you have discrete data in separate columns, use a bar graph Not suited for percentages and proportions.
To display data as a percentage of the whole, you'd better use a pie chart or a stacked column. Not recommended for schedules. While line charts are great to show trends over a certain period, a visual view of projects scheduled over time is better done by a Gantt chart.
How to make a line graph in Excel To create a line graph in Excel , , and earlier versions, please follow these steps: Set up your data A line graph requires two axes, so your table should contain at least two columns: Excel line chart types In Microsoft Excel, the following types of the line graph are available: How to customize and improve an Excel line chart The default line chart created by Excel already looks nice, but there is always room for improvement.
To give your graph a unique and professional look, it makes sense to begin with the common customizations such as: Adding, changing or formatting the chart title. Moving or hiding the chart legend. Changing the axis scale or choosing another number format for axis values. Showing or hiding the chart gridlines. Changing the chart style and colors. Additionally, you can do a few customizations specific to a line graph as explained below.
How to show and hide lines in the chart While making a graph with multiple lines, you may not want to display all the lines at a time. So, you can use one of the following methods to hide or remove the irrelevant lines: Hide columns. In your worksheet, right-click a column you don't want to plot in the graph, and click Hide.
Was this information helpful?
Once the column is hidden, the corresponding line will disappear from the graph straight away. As soon as you unhide the column , the line will be right back. Hide lines in the chart. If you don't want to mangle the source data, click the Chart Filters button on the right side of the graph, uncheck the data series you want to hide, and click Apply: Delete a line. To permanently delete a certain line from the graph, right-click it, and select Delete from the context menu. Dynamic line graph with check boxes. To show and hide lines on the fly, you can insert a check box for each line, and make your graph respond to selecting and clearing the check boxes.
The detailed instructions to create such a graph can be found here. Change data markers in a line graph When creating a line chart with markers, Excel uses the default Circle marker type, which in my humble opinion is the best choice. If this marker option does not fit well with the design of your graph, you are free to choose another one: In your graph, double-click on the line.
This will select the line and open the Format Data Series pane on the right side of the Excel window. Optionally, make the markers larger or smaller by using the Size box. Change color and appearance of a line If the default line colors do not look quite attractive to you, here's how you can change them: Double-click on the line you want to re-color. Even more formatting options are available on the Chart Tools tabs Design and Format that activate when you select the chart or its element.
August 30, at Svetlana Cheusheva says: August 30, at 1: Look up with multiple criteria If you'd like to return multiple matches, you will find a solution in this tutorial: Post a comment Click here to cancel reply. Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
Add-ins for Microsoft Excel - Calculate dates and time See all products. Add-ins Collection for Outlook These 8 tools will boost your inbox productivity and simplify your emailing routine. Plug-ins for Microsoft Outlook - Apps for Excel for Mac. Add-ins for Microsoft Excel online. Add-ins for Microsoft Outlook online.
Add-ons for Google Sheets. Add-ons for Google Docs. Add-ons for Microsoft Word - Find broken links.
Video of the Day
Development Tools. Create Office add-ins in. Actual versions Previous versions. Contact us Support forum Frequently asked questions How to activate your license Corporate deployment Useful links. All rights reserved. Microsoft and the Office logos are trademarks or registered trademarks of Microsoft Corporation. Incredible product, even better tech support…AbleBits totally delivers! Anyone who works with Excel is sure to find their work made easier.
The best spent money on software I've ever spent! Ablebits is a fantastic product - easy to use and so efficient. Excel is at its best now. I don't know how to thank you enough for your Excel add-ins. Anybody who experiences it, is bound to love it! AbleBits suite has really helped me when I was in a crunch!
I have enjoyed every bit of it and time am using it. Whether you want to highlight a set of values for emphasis or for contrast, use Excel's combination charts to achieve your objective. As their name makes clear, these multifaceted data presentations enable you to use more than one type of chart together, sharing the same X and Y axes.
Enter the data for a chart that includes at least two data series.
Select data for a chart in Excel for Mac
Each row or column of data in your worksheet constitutes a series, with the columns defining the series that display by default along the horizontal or X axis of a chart. Use the first row and column of your worksheet to enter labels that identify your data. Click and drag through the cells in which you entered your data to select all the series you want to include in your chart.
If your worksheet contains a large number of active rows or columns, you can click on the intersection of the row and column headings to select the entire worksheet. Switch to the Charts tab of the Excel ribbon and select a chart type from the Insert Chart group.
Working with Multiple Data Series in Excel | Pryor Learning Solutions
Most combination charts meld together a column or bar chart with a line chart. Click on one of its columns or bars to select the data series you want to change to a different chart type. Elizabeth Mott has been a writer since Mott has extensive experience writing advertising copy for everything from kitchen appliances and financial services to education and tourism.
How to Build a Chart in Excel. How to Add an Overlay to Excel. Share on Facebook. Step 1 Enter the data for a chart that includes at least two data series. Step 2 Click and drag through the cells in which you entered your data to select all the series you want to include in your chart. Step 3 Switch to the Charts tab of the Excel ribbon and select a chart type from the Insert Chart group.
Step 4 Click on one of its columns or bars to select the data series you want to change to a different chart type.