change x axis date scale on multiple charts quarterly

Have multiple charts to update weekly during a calendar quarter, need to
change the x axis date scale on every chart quarterly.
Can the x axis date range be changed on multiple charts simultaneously ?

If your x axis range comes from a series on your spreadsheet, changing the
values in the spreadsheet will change all the charts which use that series
to define the x axis.
--
David Biddulph

Paul wrote:
Have multiple charts to update weekly during a calendar quarter, need
to change the x axis date scale on every chart quarterly.
Can the x axis date range be changed on multiple charts
simultaneously ?

This probably doesn't work in this case, or the OP would just think Excel is
magic and updates automatically.

If you are not using Excel 2007, you can format the scale of one chart's X
axis, then select the corresponding axis of each subsequent chart, and press
the F4 function key to repeat that last action.

In Excel 2007 the functionality has been trivialized, so it only changes the
last part of the scale that you've changed. If all you changed was the
maximum, it's probably still useful to you (though I've just checked, and in
this case F4 changed nothing in the second chart)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"David Biddulph" groups [at] biddulph.org.uk wrote in message
...
If your x axis range comes from a series on your spreadsheet, changing the
values in the spreadsheet will change all the charts which use that series
to define the x axis.
--
David Biddulph

Paul wrote:
Have multiple charts to update weekly during a calendar quarter, need
to change the x axis date scale on every chart quarterly.
Can the x axis date range be changed on multiple charts
simultaneously ?