'Conditional' Scatter Plot

[dan_l]

Ok, I've got two series of data:


[sales] [salary] [sales] [salary]


Series 1 is _all data_ except for the area I want to highlight. Series 2 is just the highlighted series. It's determined with some if formulas, so in the end it looks like


[sales] [salary] [sales] [salary]

1 10

5 20

8 24

2 18


The first series plots out just fine. The second series refuses to move off the left hand side of the chart. I've tried putzing with the axis, tried double checking the data. I can't figure out what's wrong.

 

[Hui]

You Should have 2 sets of Data

Set 1 is sales and salaries and is plotted as a Scatter Chart using data in columns A (X Axis) & B (Y Axis)

Set 2 is sales and salaries and is plotted as a Scatter Chart using data in columns C (X Axis) & D (Y Axis)


Does Set 2 have a different X-Axis set of data to Set 1?


It sounds like set 2 doesn't have an X Series of Data at all and that is why it is on the left axis,

Right click the chart and Select Data, ensure each series has the correct ranges selected