Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Monthly Contact Chart
Tried to find my answer in previous posts.....need help.
I want to make a bar chart showing each months progress (Jan thru Dec) for customer contacts. Of these contacts there would be 2 types; phone and e-mail. I'd like the chart to show all the contacts per month with one bar per month and the bar to show total contacts with them separated by two different colors. I can seem to get the totals, but can't figure out how to include both types in one column. Tried a goggle search....no luck. TIA Bg |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Monthly Contact Chart
If your data is set up with Customer in the first column, Month in the
second column, Email counts in Column C and Phone in column D: Cust Month Email Phone CustA Jan 94 90 Feb 93 78 Mar 90 92 CustB Jan 10 57 Feb 53 76 Mar 66 30 You can create a stacked column chart, and it will show each customer with phone and email totals for each month. Bob G wrote: Tried to find my answer in previous posts.....need help. I want to make a bar chart showing each months progress (Jan thru Dec) for customer contacts. Of these contacts there would be 2 types; phone and e-mail. I'd like the chart to show all the contacts per month with one bar per month and the bar to show total contacts with them separated by two different colors. I can seem to get the totals, but can't figure out how to include both types in one column. Tried a goggle search....no luck. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Z Chart i.e. top rolling annual bottom rolling monthly middle cum. | Excel Worksheet Functions |