I need to produce a stacked bar graph that shows 2 different series from each record. My database compares internal pay data vs market data (the 2 different series). Each series has 3 fields for the stacked info (Base salary, Incentive, LTI).

I can create a graph that shows the stacked info for 1 series, but can't figure out how to show a second series from the same row/record in the database. Is there something simple that I'm missing?

I know it's easy to set up this kind of graph in Excel, but messing around w/the formating/labeling for what could end up being hundreds of graphs (that could all substantially change formatting-wise at my bosses whim) will take forever w/the quantity that I will need. I figured that Access would be the answer.

I'm not very experienced w/SQL, but I was wondering if maybe an SQL query might be able to help??

I've been searching around for any other (reasonably priced) tools that may help, but have been coming up dry. Any suggestions on this front?

Thanking you in advance!!

I know very little about graphing but I think that you need to use a crosstab query so that you end up with one column for each series. You want to end up with a column for InternalPay and a column for MarketPay and three rows.

Or, if that's all wet, you need to add an additional column to the query so that you have two rows. One for InternalPay and the second for MarketPay. This way you have one row for each series.