I have a set of data that I'm trying to graph using stacked bars and line in the same time. the data consists of project name, demand, capacity and period

 

my problem is I can't graph the capacity as stacked bar values with the demand as line graph together.

 

it's a little bit hard to explain but I'll do my best. 

 

the stacked bar is my different projects Y is the total of my projects capacity and the X axis is the periods. I want to add a line (overlay graph) for the demand so I have a coumn representing capacity and a line graph representing demand on the same chart. it would be nice if I can upload a snapshot of what I want it to took like but I can't attach images.

 

any help is appreciated.

thanks

 

 

as I said it's a little bit hard to explain. your method will not work. here is a sample of my data and what it should look like.

 

since I can't attach files I uploaded the image to my personal website.

 

 

 

thank you for your help.

all my information are dynamic. I used to use very simple reporting tool that had an option for displaying overlay graph and it's as simple as one click and choose which field I want to use..... very surprised that Crystal doesn't support that.

 

thanks again