Chart to represent sale number by individual contrubtion vs total
 

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.

Chart to represent sale number by individual contrubtion vs total
 

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Li Hia" wrote:

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.