Search This Blog

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.

1 comment:

  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