Insert a linein chart how to#
Insert a linein chart series#

“Line graph” has a different meaning in the world of mathematics. Marked Line Graph: The marked versions of each 2-D graph add indicators at each data point.ģD Line: Similar to the basic line graph, but represented in a 3D format. The top line will always appear straight across the top of the graph and a period’s total will be 100 percent. Therefore, the lines will never cross.ġ00% Stacked Line: This graph is similar to a stacked line graph, but the Y axis depicts percentages rather than an absolute values. Each additional set is added to the first, so the top line is the total of the ones below it. Stacked Line: This option requires more than one data set. Line: If there is more than one data series, each is plotted individually. Excel offers a number of different variations of the line graph. When the steps differ for other versions of Excel, they will be called out after each step.Ĭreating a single line graph in Excel is a straightforward process.

Insert a linein chart how to#

In the following tutorial, we’ll show you how to create a single line graph in Excel 2011 for Mac. WorkApps Package your entire business program or project into a WorkApp in minutes.Digital asset management Manage and distribute assets, and see how they perform.Resource management Find the best project team and forecast resourcing needs.Intelligent workflows Automate business processes across systems.Governance & administration Configure and manage global controls and settings.Streamlined business apps Build easy-to-navigate business apps in minutes.Integrations Work smarter and more efficiently by sharing information across platforms.

Secure request management Streamline requests, process ticketing, and more.

Process management at scale Deliver consistent projects and processes at scale.

Content management Organize, manage, and review content production.

Workflow automation Quickly automate repetitive tasks and processes.

Team collaboration Connect everyone on one collaborative platform.

Smartsheet platform Learn how the Smartsheet platform for dynamic work offers a robust set of capabilities to empower everyone to manage projects, automate workflows, and rapidly build solutions at scale.

Dipped quite low twice and unfortunately ended the year below it. This chart makes it easy to see that we spent most of the year within the target range. It does not always take much to go beyond the standard chart options available. So it was very simple to add a target range to our line graph, but very effective. The Horizontal Gridlines, Legend and maybe even Chart Title can all be removed from the chart. You can change the fill colour of the target range to something different such as grey.

Insert a linein chart series#

Select the Fill & Line category of the Format Data Series pane and select No Fill. With the orange (bottom target) series selected. In the preview, you can see that we now have the line graph over 2 stacked columns.ĭouble click a stacked column on the chart to open the Format Data Series pane on the right (these steps are in Excel 2016, they may appear different). Right mouse click on the Orange line (this is not always easy) and select Change Series Chart Type from the menu.Ĭhange the Chart Type for Series 2 and Series 3 from a Line to a Stacked Column. This is not a problem as I do not plan to use it. The Legend shows Series 1, 2 and 3 because I did not select the headers of the data when creating the chart. This does not look like much a the moment but will take shape shortly. The blue line shows the value, whilst the orange and grey are the bottom target and difference values. Insert a basic line graph by clicking the Insert tab and then the Line chart button and the first option in the list. Select the two shaded areas by selecting the months and values, then pressing the Ctrl key while you also select the bottom target and difference values. It is only used to calculate the Difference (size of the target range) with a simple Top Target – Bottom Target calculation. The Top Target column is not used at all. The Bottom Target and Difference columns are used for the target area. The Month and Value columns will be used as the data for the line graph. The colouring of the areas is used just for visual purposes and not necessary for the task at hand.