First hi everyone,

So until now i used Excel 2003, but recently got the new 2007 version.

In the old version i need about 10 seconds to do it, but in the new one i just can't figure it out.

So, how can i put 2 different charts in one?

example:

Speed - this needs to be a bar graph
Distance - this needs to be a line graph

How can i make both in one graph, so that is looks something like this:

200 |____________________________________| 20
150 |____________________________________| 15
100 |____________________________________| 10
50 |____________________________________| 5
0 |____________________________________| 0

Then the bar and line graphs in the middle???