Overlay Line Chart and bar Graph

[kingngoyu]

Hi,

I have 5 companies with historical data for 5 years for 2 different categories, I want to create a bar chart of the first with each 5 companies so a bar for each year then a space, then the next company and so on. Then overlay that with the second category as a line chart so that would be 5 sets of 5 bars and 5 lines (1 over each set of 5 bars) on the graph in total, cheers for any help

 

[kingngoyu]

Difficult isn't it...

 

[Trevor G]

Look at a combination chart to achieve this. Please let us know which version of office you are using to help you find a solution, also if you can look at youtube when you type in combination chart in Google