Hi,

Sounds like you need to edit the x values data ranges for your series so
they all use the same set of x values.
Use the source data dialog to update your data references.
Or is the chart is on a worksheet select the data series and then drag
the coloured highlighting box over to the shared x-values range.

Cheers
Andy

JethroUK© wrote:
If I want to change x-values in a multi-series X-Y scatter

I have to edit x-values seperately for each series

e.g i have 7 series - i have to edit all 7 x-values (even though the new
x-values are the same for all series)

i must've missed something - isn't there a way to set the same x-values for
all series at once

no-coding solutions - thanx





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info