Chart to represent sale number by individual contrubtion vs total

  • Thread starter Thread starter Li Hia
  • Start date Start date
L

Li Hia

I need help on how to create a chart to represent sales number by individual
contributor vs total.

E.g.
Alvin = $50
Mary = $150
John = $80
Kate = $120
Total = $400

The chart should show a graphical representation of $400 as the total, and
it shows how each person contribute to the chart.
 
Hi,

One way would be to plot the data, not including the total as a stacked
column. Alternately, you could plot the data without the total as a column
chart and then plot the total as a line on the same chart. Just make a
second series with each item the total.
 
Back
Top