How do I set up a Y-scatter chart?
My data are site 1 (values 0.1, 2, 3, 4.5 ) and site 2 (0.2, 4, 5, 10.5)? I
want the x-axis to be fixed with the site name and y-axis variable with the
data.
How do I set up a Y-scatter chart?
My data are site 1 (values 0.1, 2, 3, 4.5 ) and site 2 (0.2, 4, 5, 10.5)? I
want the x-axis to be fixed with the site name and y-axis variable with the
data.
This is not an XY scatter but a Line chart becaue your x-values are
categories not numeric value
In A1 enter the text Site 1, in B1 the text Site 2
In A2:A5 enter values 0.1, 2,3,4.5; in B2:B5 enter 0.2, 4,5,10.5
Select A1"B5, click on Chart Wizard, Specify LINE chart
In Stage 2 of Chart wizard change BY COLUMN to BY ROW
Continue to end of Chart Wizard
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Carolina Blue" <Carolina [email protected]> wrote in message
news:[email protected]...
> How do I set up a Y-scatter chart?
>
> My data are site 1 (values 0.1, 2, 3, 4.5 ) and site 2 (0.2, 4, 5, 10.5)?
> I
> want the x-axis to be fixed with the site name and y-axis variable with
> the
> data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks