possible to chart two sets of data (4 columns) with common X & Y axes?

[Todd Ogasawara, MVP Mobile Devices]

Is there a way to combine two sets of data with common X & Y axes on a
scatter chart that lets the viewer see that there are two clusters of data
(say with different point types or colors)? Here's an example:

Column 1: Test session
Column 2: Distance traveled under condition 1
Column 3: Travel time under condition 1
Column 4: Distance traveled under condition 2
Column 5: Travel time under condition 2

Columns 2/4 and 3/5 are the Y & X axes respectively. I want to overlay the
raw data so that the clusters that emerge from condition 1 and 2 are easily
seen (different colored dots for conditions 1 or 2 or different point
shapes).

Alternatively. Can I create a "condition" column and place data from column
4 and 5 under 2 and 3 and use the condition column (value of 1 or 2) to
indicate to the chart which dot belongs to which group?

Thanks...todd

 

[Tushar Mehta]

Select the data in columns 2 and 3 and create a XY Scatter chart.

Then, select the data in columns 4 & 5 and drag onto the chart (or
copy, select the chart, and Edit | Paste Special...). In the resulting
dialog box, specify 'data in columns' and 'First column contains x
values.'

You should have two plotted series in different colors with different
shaped markers.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Todd Ogasawara, MS-MVP Mobile Devices]

Thank you, Tushar! I'll give it a try...todd

Select the data in columns 2 and 3 and create a XY Scatter chart.

Then, select the data in columns 4 & 5 and drag onto the chart (or
copy, select the chart, and Edit | Paste Special...). In the resulting
dialog box, specify 'data in columns' and 'First column contains x
values.'

You should have two plotted series in different colors with different
shaped markers.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions