Actual vs Target Chart in Excel – Target Values as Bars
An Actual vs. Target chart is a tool that is used to compare two sets of data: the actual values achieved and the target values to be reached. This type of chart is widely used in situations, such as assessing sales performance, tracking revenue targets, and many more. There are various kinds of chats in Excel for data visualization, It makes it easy to identify areas where goals are exceeded or met, providing valuable insights for strategic planning and tracking for goals.
Creating Actual Vs Target Chart In Excel With Floating Markers
Excel is known to be a powerful tool for data visualization, comparison, storage, and management which can handle large amounts of data. We know that data can be visualized and compared using different kinds of plots and charts in Excel such as line charts, bar charts, etc. The tool is used to get insights from data using formulas and functions. It is primarily used by Accounting professionals to get insights into financial data, but it can be used by anyone for different purposes. Let’s see how to create an Actual vs Target chart using floating markers:
For demonstration, let’s use the below table values, which have actual sales and target sales for different years,
Contact Us