Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in


How to add horizontal benchmark/target/base line in an Excel chart?

Step-by-step Guide

Let's say you have created a column chart to show four teams' sales amount in Excel. But now, you want to add a horizontal benchmark line in the chart, how could you handle it? This article will introduce a couple of solutions for you!

300+ tools help you stand out from the crowd now

with Kutools for Excel - never worry about job cut

Kutools for Excel brings 300+ handy tools for 1500+ work scenarios, helps you work faster and better than your colleagues, and easily win trust of your boss. You will be the last one in the list of layoffs, and easily maintain a stable and better life for your family!

  • To be a master of Excel in 3 minutes, and easily win appreciation of others.
  • Improve 70% work efficiency, solve your 80% problems in Excel, not work overtime.
  • Speed up your work, save 2 hours every day to improve yourself and accompany family.
  • Say goodbye to complicated formulas and VBA code, free up your memory.
  • Reduce thousands of keyboard operations and mouse clicks, far away from mouse hand.
  • Spend $39.0, worth more than $4000.0 training of others.
  • Choice of 110,000+ highly effective people and 300+ famous companies, work stable in Excel.
  • Full feature free trial 60-day, no credit card required.
Read More ...
Free Trial Now
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.