3 Replies Latest reply on May 11, 2017 2:56 AM by Tushar More

    Show Average All and filtered Customer in same chart

    Isaac Dayan



      Using for example the sample-Superstore

      I want to draw a bar chart, that displays the Average Sales  and Average Quantity for all users, and the avg Sales and avg Qty for some users, selected using the filter.

      I can do this in two worksheets, but I want to do this in the same graph.

      In excel it will look like this:

      Screen Shot 2017-05-09 at 1.53.41 PM.png