Course Content

  • Actual Vs Target Chart

Course Content


Step 1: Select the data, then go to insert, chart, then clustered column chart from the drop-down menu. The chart below will show the target and actual values separately. Step 2: You have the option of changing the colour of your bars. Change the series chart type by right-clicking the target bar.

  • Make a selection of the complete data set.
  • Select Insert Tab from the drop-down menu.
  • Select the 'Clustered Column Chart' icon from the Charts Group.
  • Select any of the bars for Target Value in the inserted chart in the spreadsheet.
  • Right-click on the target bars and choose 'Change Series Chart Type.'

Funnel charts are a sort of graphic that shows the amount of possible revenue for each stage of a sales process. This type of graphic can also be used to highlight possible problems in a company's sales procedures. A funnel chart resembles a stacked % bar chart in appearance.

  • when the data is sequential and moves through at least 4 stages.
  • when the number of "things" in the first stage is projected to be more than the final stage's number.
  • to determine potential (income, sales, deals, and so on.)
  • to figure out how to compute and track conversion and retention rates

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere