Help needed on column stack graph

[mahershams]

Please kindly help me to create column stack graph using the attched excel data. There will be 11 columns and three stacks for each column. Thanks for help.

[RHCPgergo]

Hi,

I attached a solution. Please note that I rearranged your data a little. Also, I only have Excel 2003 here, so it's saved in that format.

[mahershams]

Thank you very much for quick solve. Sorry to ask for another help. I would like to add three lines graph as well which will be represent
the right vertical axis. Is it possible.

One more thing, is it possible to prsent the each stack column as 100 percent sothat all the columns are in same length but the stack has different length inside the column to increase the visibility of each stacks.

Thank you very much.

[RHCPgergo]

No problem. To changed the column chart you just need to change the chart type to 100% stacked column. I did it for you in the file I attached.

As for the line graph, do you mean it separetely or on the same chart? I can do it separately but not on the same chart... I think it's possible but I don't know how.

[mahershams]

Hi

I need a help on a line graph attached in the excel sheet. How to presesnt this graph in more visible way. Now it looks very messy. How to make it better graph? Any help.

Highly appreciated your feedback.

Thanks

[RHCPgergo]

Hi,

please start a new thread next time.

As for this one, I don't really know how it could be "more visible". Maybe change the colors of the lines to be more distinguishable. Also you can display major gridlines in the chart to be able to identify value points better.

Or you could display the six series on different charts. Like one chart for Stock and one for Cash .

[mahershams]

Hi sorry for this. I mistakenly did this. Thanks for help again. So there is no way to present all of them in one graph. Thanks