Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the X axis scale on all charts in a workbook? | Charts and Charting in Excel | |||
Grouping axis scale multiple charts | Charts and Charting in Excel | |||
How to correctly scale X-Axis in Charts? | Excel Discussion (Misc queries) | |||
Excel Charts - Data being Plotted beyond Primary X-Axis Scale | Charts and Charting in Excel | |||
Locking the scale ratio of X-Y axis in XY scatter charts | Charts and Charting in Excel |