Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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 wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
I want to ignore invalid values in scatter chart | Charts and Charting in Excel | |||
Scatter Chart Axis as text in C# Web appl | Charts and Charting in Excel | |||
On a scatter chart show two point have same value | Charts and Charting in Excel |