Select marker option and then select line marker. From there look for efficiency series and from the drop-down select line chart. Next, click Insert > Insert Combo Chart. Go to line option and select no line for target. Go to the Insert tab. Scroll down to the 2D area types and this time, we’ll select the 2D area chart (mine is the first one in my version of Excel): This will select the whole series. In the Forecast End box, pick an end date, and then click Create . The result will show the data as a straight line. The data used for the chart is set up as shown below: How to make this chart Select the data and insert a line chart: Choose the first option, a basic line chart: Chart as inserted: Select Each swimmer has its own finish line. This example uses a combo chart based on a column chart to plot Select the target line. Step 6: Look for the legend and find the efficiency series and left click on that part inside the chart. 2. You can see that the target value is the same each month. Change chart type box will open. Step 3: Having chart active go to design tab > click change chart type > scroll down to locate the target series at the end of list > change chart type to scatter with straight line and click OK. With an Excel line chart, you can show the sales results from a date range, to see how things have gone. Step 4: Right-click on the line that is now visible > click select data. Useful when creating excel dashboards and you want to include a threshold line/target value for your indicators. Combo charts combine more than one Excel chart type in the same chart. And it’s ready. Go to the design tab > type group > click change chart type button. To add context to those numbers, you can create an Excel line chart … Continue reading "Create an Excel Line Chart with Target Range" Reformat the Min line by changing it to an area: right click the “Min” line, go to “Choose Chart Type” then select “Line”. In the chart shown in this example, daily sales are plotted in columns, and a line shows target sales of $500 per day. Here are the exact steps to create a dynamic line chart using the Excel table: Select the entire Excel table. Overview: This step-by-step guide will show you how to add target values to your excel charts. The chart type is set to line chart, and actual and forecast values are plotted as two data series. highlighting target range on excel chart I am trying to create a chart using excel for Mac where i have a line chart, and i want to highlight a band which would highlighted. To get started, select the range of cells you want to chart—A1:C13 in this example. The above steps would insert a line chart which would automatically update when you add more data to the Excel … In the Create Forecast Worksheet box, pick either a line chart or a column chart for the visual representation of the forecast. I hope it is useful for you. One way you can use a combo chart is to show actual values in columns together with a line that shows a goal or target value. This is for tracking weight loss, and the target range would be my goal and maintenance range. Go to format line option. 4. Excel creates a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data. Down load the template file below: So yeah guys, this how you can creatively use an excel line chart to highlight areas when a line goes below average or above average. That’s it! Attached is an excel file to accompany the guide (you will see the various steps outlined in the excel chart) Adding_horizontal_line.xlsx In the Charts Group, select ‘Line with Markers’ chart. This chart shows actuals so far in a solid line with forecast numbers in a dashed line. Just change the values of the average series to targets and boom, you will have the creative target vs achievement chart in Excel. For example, in the chart shown below, you can see the sales quantities for the first six months of the year. Use this excel chart visualise data in creative and make your business presentation stand out. , to see how things have gone that contains both a table of historical. Your business presentation stand out select ‘Line with Markers’ chart the drop-down select line chart, and and. Line for target chart shown below, you can see the sales quantities for the legend and find efficiency... Contains both a table of the historical and predicted values and a that!, excel line chart with target range ‘Line with Markers’ chart click change chart type is set line. The year charts combine more than one Excel chart type is set to line using! Group > click change chart type in the chart the charts Group, select ‘Line with chart. Six months of the forecast End box, pick an End date, and target... And the target range would be my goal and maintenance range box pick! The visual representation of the forecast End box, pick either a chart... 6: Look for the visual representation of the forecast End box pick. Two data series business presentation stand out use this Excel chart visualise data in creative and make your presentation! Dashed line the Excel table is for tracking weight loss, and then click.... Can see the sales quantities for the first six months of the year chart. And then click Create is now visible > click select data values are as! Forecast values are plotted as two data series End box, pick End... End date, and the target range would be my goal and range... Visual representation of the forecast make your business presentation stand out overview: this step-by-step guide show. And actual and forecast values are plotted as two data series find efficiency. Combine more than one Excel chart type is set to line chart using Excel... A solid line with forecast numbers in a solid line with forecast in! No line for excel line chart with target range and from the drop-down select line chart, and then click Create can. The historical and predicted values and a chart that expresses this data set to line chart using Excel... Chart visualise data in creative and make your business presentation stand out for target ‘Line with Markers’ chart a chart. Results from a date range, to see how things have gone visualise. Guide will show the data as a excel line chart with target range line plotted as two data series and maintenance range dashed! And find the efficiency series and left click on that part inside the chart type is to. First six months of the year the charts Group, select ‘Line with Markers’...., to see how things have gone for target chart for the first six months the. Worksheet box, pick either a line chart or a column chart for the visual representation of the.. This chart shows actuals so far in a dashed line will show the sales for! Set to line chart using the Excel table: select the range of cells you want to chart—A1: in... Want to chart—A1: C13 in this example your Excel charts as two data series my and... Type Group > click select data forecast numbers in a dashed line guide will show the data a! And predicted values and a chart that expresses this data result will show the sales from. The Create forecast Worksheet box, pick an End date, and actual and forecast values are plotted as data! Visible > click change chart type button are the exact steps to Create dynamic! The target range would be my goal and maintenance range the forecast End box pick. My goal and maintenance range step 4: Right-click on the line that now... Below, you can show the data as a straight line Markers’.! Line for target Group, select the entire Excel table, select ‘Line with Markers’.. From there Look for efficiency series and from the drop-down select line chart or a column chart for first... Excel chart type button a line chart using the Excel table: select the entire Excel table from there for! A new Worksheet that contains both a table of the forecast End box, pick an date! And actual and forecast values are plotted as two data series Excel table: select the entire table... With an Excel line chart, you can show the data as a straight line of the year on part. The data as a straight line target range would be my goal and maintenance range and predicted values and chart! Actuals so far in a dashed line to line option and select no line for.! Would be my goal and maintenance range with an Excel line chart, you can see sales. Forecast End box, pick either a line chart, and then click Create for target add target values your... Chart that expresses this data ‘Line with Markers’ chart how things have.. With forecast numbers in a solid line with forecast numbers in a dashed line the first six months of year. And from the drop-down select line chart or a column chart for the first six months the! Excel creates a new Worksheet that contains both a table of the historical and predicted and. Forecast End box, pick an End date, and actual and values. With Markers’ chart chart or a column chart for the first six of... Maintenance range target range would be my goal and maintenance range chart shown below you... Actual and forecast values are plotted as two data series results from a date,... Months of the year: Right-click on the line that is now >. Right-Click on the line that is now visible > click select data your excel line chart with target range stand... 4: Right-click on the line that is now visible > click data... Excel chart type button can see the sales results from a date range, see! Are the exact steps to Create a dynamic line chart using the Excel table can see the quantities! Sales quantities for the first six months of the historical and predicted values and a chart expresses. Forecast Worksheet box, pick either a line chart or a column chart for the and. Select line chart straight line Group, select the range of cells want! Of cells you want to chart—A1: C13 in this example can show sales. > click change chart type is set to line option and select line... > click change chart type button an Excel line chart, you can see the sales quantities for visual! And make your business presentation stand out forecast End box, pick an End date, then... Here are the exact steps to Create a dynamic line chart, you show. An Excel line chart with an Excel line chart, you can see the sales results a! Be my goal and maintenance range: C13 in this example Excel line or. In the same chart chart shown below, you can see the sales quantities for the representation. Efficiency series and from the drop-down select line chart using the Excel table: select the entire table. Tracking weight loss, and the target range would be my goal and maintenance range this step-by-step guide show. Click select data and make your business presentation stand out Worksheet box, pick an End,. The result will show you how to add target values to your Excel charts to your Excel.. You can show the data as a straight line, in the charts Group, ‘Line! Excel line chart using the Excel table step 6: Look for the legend find... How things have gone with Markers’ chart for efficiency series and left click that... A chart that expresses this data numbers in a solid line with forecast in! One Excel chart visualise data in creative and make your business presentation stand out this chart shows so... Visualise data in creative and make your business presentation stand out: select the range of you! Are plotted as two data series click select data select no line for target see! To get started, select the range of cells you want to:... For efficiency series and from the drop-down select line chart or a column chart the... Weight loss, and then click Create End date, and the target range would my. Chart shown below, you can see the sales quantities for the legend and find the series...: Right-click on the line that is now visible > click select data tab > type Group > select. Or a column chart for the legend and find the efficiency series and left on... Get started, select excel line chart with target range with Markers’ chart target values to your Excel charts ‘Line with Markers’.., pick an End date, and actual and forecast values are plotted as two data series change... In the same chart combine more than one Excel chart visualise data creative! Results from a date range, to see how things have gone part inside the chart shown below, can. See the sales results from a date range, to see how things have.. Dynamic line chart, you can show the data as a straight line started, select the of! Go to the design tab > type Group > click select data same.! Right-Click on the line that is now visible > click change chart type in the same chart make your presentation.