XY-Scatter Chart With 4 Axes

monirg

Well-known Member
Joined
Jan 11, 2005
Messages
629
I have: data point P1(x1, y1); uses the primary X-Axis & primary Y-Axis, and data point P2(x2, y2); uses the secondary X-Axis & secondary Y-Axis.

Can someone please tell me how to join P1 and P2 by a straightline ??

I've tried couple of ideas with no success !

Thank you.
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
Given the variances in the scales, I'm struggling to understand the value that this line would add.

That aside, your best bet may be to use the drawing toolbar to connect the dots manually...
 

Watch MrExcel Video

Forum statistics

Threads
1,118,323
Messages
5,571,544
Members
412,402
Latest member
xam99
Top