If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 ? |
#2
|
|||
|
|||
change x axis date scale on multiple charts quarterly
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 ? |
#3
|
|||
|
|||
change x axis date scale on multiple charts quarterly
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 ? |
Thread Tools | |
Display Modes | |
|
|