How to show 2 sets of datasets in a stacked column chart?

J

Judy 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.
 
B

Bob Greenblatt

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.
 
J

Judy Felfe

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.
 
B

Bob Greenblatt

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
 
J

Judy Felfe

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top