Highlight the forecasted revenue line and click on the box icon with a plus sign inside called CHART ELEMENTS.
Select DATA LABELS.
Click on the black directional arrow and select ABOVE.
How do you compare sales performance in Excel?
Open a blank workbook in Microsoft Excel. Enter the category you want to compare in cell A1. For instance, to compare different products, enter "Product." In the cells below, enter the name of each product. You could also use a column chart to compare sales in different regions.
How do you create a comparison chart in Excel?
Select the data, including both series and headers (all three columns).
Click the Chart Wizard button on the Standard toolbar or choose Insert –> Chart.
Bar charts are good for comparisons, while line charts work better for trends. Scatter plot charts are good for relationships and distributions, but pie charts should be used only for simple compositions — never for comparisons or distributions.