3 lots of information to be put on a chart

Is it possible to input 3 lots of data onto a chart, ie:

Sold Received Percentage
Aug 1 1120 0.09
Sep 1 1055 0.06
Oct 0 1035 0.00

I want to be able to see this on a chart. Am I way too in the clouds or can
it be done?

--
Em

EmJay80,
This is what I came up with:
A B C D
1 Sold Received Percentage
2 Aug 1 1120 0.09
3 Sep 1 1055 0.06
4 Oct 0 1035 0.00

Select the data: Cells A14
Select Chart Wizard, select "Custom Types" tab.
Scroll down and select " Line - Column on 2 Axes", then "Next".
"Data Range" tab, select "Columns", select "Series" tab.
In the "Series" area, select the first series in the list.
"Name:" type "=Sheet1!$B$1" (if it is sheet1) or better select the cell that
"Sold" is in.
Select the second series in "Series:", in "Name:" type "=Sheet1!$C$1" or
better select the cell that "Received" is in.
Select the third series in "Series:", in "Name:" type "=Sheet1!$D$1" or
better select the cell that "Percentage" is in.
Select "Next" and "Finish" to make it part of the Worksheet.
Select the left Y-axis, by double clicking on it. Change scale to 0 to 1.5.
Select the right Y-axis and change scale to 0 to 1200.
You may want to "Label Values" on the chart also.
hth

"EmJay80" wrote:

Is it possible to input 3 lots of data onto a chart, ie:

Sold Received Percentage
Aug 1 1120 0.09
Sep 1 1055 0.06
Oct 0 1035 0.00

I want to be able to see this on a chart. Am I way too in the clouds or can
it be done?

--
Em

Thanks FloMM2, really appreciate the help there.
--
Em


"FloMM2" wrote:

EmJay80,
This is what I came up with:
A B C D
1 Sold Received Percentage
2 Aug 1 1120 0.09
3 Sep 1 1055 0.06
4 Oct 0 1035 0.00

Select the data: Cells A14
Select Chart Wizard, select "Custom Types" tab.
Scroll down and select " Line - Column on 2 Axes", then "Next".
"Data Range" tab, select "Columns", select "Series" tab.
In the "Series" area, select the first series in the list.
"Name:" type "=Sheet1!$B$1" (if it is sheet1) or better select the cell that
"Sold" is in.
Select the second series in "Series:", in "Name:" type "=Sheet1!$C$1" or
better select the cell that "Received" is in.
Select the third series in "Series:", in "Name:" type "=Sheet1!$D$1" or
better select the cell that "Percentage" is in.
Select "Next" and "Finish" to make it part of the Worksheet.
Select the left Y-axis, by double clicking on it. Change scale to 0 to 1.5.
Select the right Y-axis and change scale to 0 to 1200.
You may want to "Label Values" on the chart also.
hth

"EmJay80" wrote:

Is it possible to input 3 lots of data onto a chart, ie:

Sold Received Percentage
Aug 1 1120 0.09
Sep 1 1055 0.06
Oct 0 1035 0.00

I want to be able to see this on a chart. Am I way too in the clouds or can
it be done?

--
Em