If they're both XY: select one chart, copy, select the other chart, Edit menu >
Paste Special > Formulas. This puts the data from the copied chart into the pasted
chart.
If they are column/line/area types, the X axes are connected with the first series
in the chart, so there may be more complicated steps you need to take.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions http://PeltierTech.com/
_______