Format Axes in Line Graphs

[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

 

[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