 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / May 2008How to show 2 sets of datasets in a stacked column chart?
For each month of the year, I would like to show 2 stacked columns. Each column represents the costs for one insurance plan and is comprised of three items (employee coshare + employee contribution + Employer cost). How can I do this? Thanks in advance.  SignatureJudy Felfe On 5/27/08 3:16 PM, in article 00ED29C0-1667-4A00-ACC1-4F0CE9EE852C@microsoft.com, "Judy Felfe" <JudyFelfe@discussions.microsoft.com> wrote: > For each month of the year, I would like to show 2 stacked columns. Each > column represents the costs for one insurance plan and is comprised of three > items (employee coshare + employee contribution + Employer cost). How can I > do this? Thanks in advance. Just set up your data with the left most column containing titles like coshare,contributiion, and cost. One row above, and one column to the right add the plan titles. Then fill in the intersections with the values, and select any of the stacked column charts. If necessary right click the chart select select data, and then click switch row and columns. SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom This only works for one month. I would like to show 2 stacked columns for each month of the year. Is there a way to do this? Thanks again in advance. SignatureJudy Felfe > For each month of the year, I would like to show 2 stacked columns. Each > column represents the costs for one insurance plan and is comprised of three > items (employee coshare + employee contribution + Employer cost). How can I > do this? Thanks in advance. On 5/28/08 9:08 AM, in article 0D7147E4-8432-4890-ABC4-F01C6B22BFDC@microsoft.com, "Judy Felfe" <JudyFelfe@discussions.microsoft.com> wrote: > This only works for one month. I would like to show 2 stacked columns for > each month of the year. Is there a way to do this? Thanks again in advance. It certainly should work fine. Can you send me your workbook so I can see what is wrong SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom The charts are on the Chart Cost by Plan sheet. I guess I will have to send you the workbook in a separate msg, which I will attempt to do right now. Thanks a million. SignatureJudy Felfe > On 5/28/08 9:08 AM, in article > 0D7147E4-8432-4890-ABC4-F01C6B22BFDC@microsoft.com, "Judy Felfe" [quoted text clipped - 4 lines] > It certainly should work fine. Can you send me your workbook so I can see > what is wrong |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.