Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW CAN A LETTER IE A ,B OR C REPRESENT A NUMBER IE 0.5 OR 2 ETC.. | Excel Discussion (Misc queries) | |||
Individual column width to represent stacked total | Excel Discussion (Misc queries) | |||
how to now what date represent a serial number? | Excel Worksheet Functions | |||
How to determine total value of business for sale | Excel Worksheet Functions | |||
If function with date; if sale is Oct place sale $ amount here | Excel Worksheet Functions |