PDA

View Full Version : Charting question



peacenik
01-23-2007, 06:23 PM
This is not really a VBA question, but I am hoping that someone here might be able to help me.

I have data for two lines of business across two years and across several states.

I would like to build a Bar chart showing the two lines of business stacked and comparing year on year next to each other with the states displayed across the x axis.

Some sample data is in the attached file.

d4vem
01-24-2007, 05:31 AM
Take a look at the attachment. Is this what you are looking for.

peacenik
01-24-2007, 02:22 PM
Thanks for your help, but no, that is not what I want. I wouild like to stack Product A and Product B, so that they can be compared year on year for each state.

mdmackillop
01-24-2007, 02:44 PM
More like this?