Format Axes in Line Graphs

A

Alex

How do you manually format axes to new data?
I have identical worksheets with different data ranges, and
I want to change the source data on identical line graphs
to reflect the new parameters.
(No Macros, please)
Thanks for your advice.
Alex
 
D

Dan E

Alex,

Right click anywhere on your chart, choose Source Data
Under the Series Tab you should be able to make the
necessary changes.

Dan E
 
Top