how do i create a chart with 4 sets of data?

[PK]

I have to create a graph holding 4 sets of data, two bar charts and two line
graphs. The other problem is that they are measured in different units - is
it even possible to plot this on a single chart?

 

[Bernard Liengme]

Create a column chart of all four data series
Right click on one in the chart; select Chart Type and convert to line
Repeat with second data series
Right click one of the data series; Format Data Series and specify Secondary
y-axis
Repeat with second data series
best wishes

 

[Lyle]

I have four sets of data. One column is the major X axies and the second is
the Y axies. The third and fourth columns are data points the correspond
with each of the major axies. How do I graph this in an area chart or XY
scatter?

 

[James Dowell]

I have four sets of data, how can I create a chart useing
Microsoft Excel 2007 with windows 7.