![]() ![]() To do that, we'll start with a different chart type, then change the chart settings later. The goal is to create a line chart, with a target range in the background. In this example, the result is 100 in each row.In cell E4, enter this formula, to calculate the difference between the high and low values:.Next, follow these steps to calculate the Target range amount: In this example, the T_Low value is 250 each month.In cells D4:D9, enter the low number for each month's target range.In this example, the T_High value is 350 each month.In cells C4:C9, enter the high number for each month's target range.In cells C3, D3 and E3, enter new headings: T_High, T_Low, Target.To add the target range data for the chart, follow these steps: To give a better picture of the sales results, you could show what the sales target range was, for each month of the year. There are records for the first 6 months of the year, and this data will be used to create a line chart. Cell A3 is left empty, but a heading could be added there.Monthly sales quantities in cells B4:B9.In this example, there is monthly sales data on an Excel worksheet: There are written steps below the video Worksheet Chart Data To see how the chart works, you can get the sample file from the download section on this page. ![]() In the data, add the high and low values for the target range,Īnd show that range in the background of the line chart. Months, and show the target sales range in the chart's background. In this video, see how to build an Excel line chart to show sales over six Get the Sample Workbook Video: Line Chart With Target Range To see how to set up this line chart and target range, there are written steps, and a video, in the sections below: That will show if sales fall within that range, for each month shown in the line chart. ![]() To add context for those number, include a shaded target range in the chart. In an Excel line chart, you can show monthly sales, over a set date range. Get the Sample Workcook Show Target Range in Excel Chart ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |