WhtChoklat
Technical User
Here is the situation...
I am currently creating an application that grabs a data dump; exports, formats, and creates a MS Access Database. It then exports the data to different Excel Worksheets and Graphs are created. I have everything working, but I can't get the graphs to reflect the data that I want them too.
Here is the Problem.
I need to create a Two Axis, Stacked Column Chart, with a line graph as the second series.
I need the XlCategory to be the assignment group (These names pertain to the Columns in my worksheet). I also need the stacked columns to be stacked by Priority. Then I need to have a line bar that reflects another number that is created.
Can someone help me or poing me in the right direction? I am shooting in the dark here.
I am currently creating an application that grabs a data dump; exports, formats, and creates a MS Access Database. It then exports the data to different Excel Worksheets and Graphs are created. I have everything working, but I can't get the graphs to reflect the data that I want them too.
Here is the Problem.
I need to create a Two Axis, Stacked Column Chart, with a line graph as the second series.
I need the XlCategory to be the assignment group (These names pertain to the Columns in my worksheet). I also need the stacked columns to be stacked by Priority. Then I need to have a line bar that reflects another number that is created.
Can someone help me or poing me in the right direction? I am shooting in the dark here.