 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / November 2003Positioning dates on chart
I am running an Excel 97 macro which updates charts. All the charts use the same long macro and change based on one data text input. Most of the charts have the dates along the bottom of the chart where I want them but a few have the dates either at the top of the chart or somewhere in between. Could someone tell me what the key settings are for having dates positioned along the bottom of the chart? Then I would put a new command at the end of the macro to ensure that these dates will be properly placed. Any suggestions would be greatfully appreciated. Thanks, Roger ___________________________ Roger Bedford Vancouver, B.C., Canada Hi Roger, > I am running an Excel 97 macro which updates charts. All the charts use the > same long macro and change based on one data text input. Most of the charts [quoted text clipped - 3 lines] > the bottom of the chart? Then I would put a new command at the end of the > macro to ensure that these dates will be properly placed. To find out which setting you need to change, double-click the Y axis of one of the charts where the labels are in the wrong place. On the 'Scale' tab, there are the options to set the X axis to cross at a specific place, or at the maximum value (at the top), while if you double-click the X axis, on the 'Patterns' tab, there are options for where to put the Tick Mark labels. Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.co.uk There is no Axis Crosses at Maximum setting. Such a setting would have made axis scaling easier. One trick to make the axis labels stay at the bottom, no matter how the data changes, is to pick a number which is ridiculously lower than the minimum you expect. For example, use -99999999 for the X Axis Crosses At value, or 0.000000001 if it's a logarithmic Y axis scale. The minimum occurs where the Minimum is set, or sets itself if you allow autoscaling, without regard for the Crosses At value. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ > Hi Roger, > [quoted text clipped - 17 lines] > Microsoft MVP - Excel > www.BMSLtd.co.uk Hi Jon, > There is no Axis Crosses at Maximum setting. Such a setting would have > made axis scaling easier. So if you double-click the Y axis and select the 'Scale' tab, what is the bottom check box on that tab? On my machine it's "Category (X) axis crosses at maximum value", which seems to have the effect of plotting the X axis at the top of the chart instead of the bottom. Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.co.uk Doh! MINIMUM. I meant, there's no Axis Crosses At MINIMUM setting. This would ensure that the axis is always at the bottom. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ > Hi Jon, > [quoted text clipped - 11 lines] > Microsoft MVP - Excel > www.BMSLtd.co.uk Hi Jon, > Doh! MINIMUM. I meant, there's no Axis Crosses At MINIMUM setting. > This would ensure that the axis is always at the bottom. Ah! Yes, that would make a difference <g>. On the patterns tab, though, we can opt to plot the axes labels at the bottom. Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.co.uk Stephen - Yes, but the axis itself isn't tied to the bottom, even though the labels are. That's the distinction. - Jon > Hi Jon, > [quoted text clipped - 9 lines] > Microsoft MVP - Excel > www.BMSLtd.co.uk Jon and Stephen, many thanks for your ideas. I used Jon's -99999999 for the X Axis Crosses At value and now they all work perfectly. Neat! Roger >Stephen - > [quoted text clipped - 16 lines] >> Microsoft MVP - Excel >> www.BMSLtd.co.uk |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.