4/4/2024 0 Comments Excel high low rangeThe high value for the monthly target is entered in column C for each month, and the low value in column D. The sales data for the chart is in columns A:B in the worksheet shown below. In the next chart, a blue band with the target range has been added, and you can quickly see which months were over or under the target amount. To give a better picture of the sales results, you might also want to show what the sales targets were for each month of the year. Here is a simple line chart with sales for January to June. To add context to those numbers, you can create an Excel line chart with target range. For example, in the chart shown below, you can see the sales quantities for the first six months of the year. With an Excel line chart, you can show the sales results from a date range, to see how things have gone.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |