Excel 2007 graph experts help

[Andy_con]

im trying to get a graph to look like the below.

ive tried a few ways but cant get it to look the same.

anyone able to help??

 

[Andy_con]

bump!

 

[Steve 182]

Yes bud i can help need to know a few things first...

As in what is the line for??

 

[Steve 182]

If you create the graph with both sets of data then right click on the one you want to be a line, change graph type of this one to a line graph and bingo done. if this doesnt help i will try an create you a quick user guide... pm me your email or something

 

[iain187]

Steve has got it, just make sure you have got 1 data series selected when you are trying to change the type (click on it in the legend, but make sure 1 series is selected not the whole legend)

 

[Steve 182]

Something like this?

This is just an example i ruffed up..

 

[Andy_con]

many thanks have managed to do it.

cheers