Wednesday, July 8, 2020

Excel Combination Chart of Sales vs Target


If you need to chart some kinds of data to a goal like sales to a target, Excel makes this easy with the combo chart of a column chart along with a line chart (initially). The columns can be the sales and the line series will represent the target. Most times this is enough when you have a target that doesn't change much. However if there are change to the target having the line vary may not looks visually appealing. Another example in this videos that is also a combo chart is actually using the combination of two column charts but have them on different y axis.

2 comments:

  1. Thanks so much for this information. I have to let you know I concur on several of the points you make here and others may require some further review. Please visit this. microsoft office home and student 2019

    ReplyDelete
  2. Free Sales Courses could be taken by large groups in organizations or individual learners and the online platform has made them accessible to many. קורס מכירות

    ReplyDelete