 |
 | 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 / August 2008not able to see tick mark label
I created a custom date-axis in the form N, D, J-YY, F,... But -YY is not always visible even after I have shrunk the size of the tick mark label. Any suggestions would be greatly appreciated. Sometimes I've seen the label wrap the text, so that the YY is on the next line, but for some reason only the first line of the label is visible. I seem to recall this happening on small charts with small fonts and a large number of labels. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ >I created a custom date-axis in the form N, D, J-YY, F,... > But -YY is not always visible even after I have shrunk the size of the > tick mark label. > > Any suggestions would be greatly appreciated. >I created a custom date-axis in the form N, D, J-YY, F,... >But -YY is not always visible even after I have shrunk the size of the >tick mark label. > >Any suggestions would be greatly appreciated. Create a second date column in the worksheet, with the same date and the format YY, and use both columns to make the date axis. This will display correctly.  SignatureDel Cotter NB Personal replies to this post will send email to del@branta.demon.co.uk, which goes to a spam folder-- please send your email to del3 instead. On Thu, 28 Aug 2008, in microsoft.public.excel.charting, I said: >e57 <tianhao.liu@gmail.com> said: >>I created a custom date-axis in the form N, D, J-YY, F,... >>But -YY is not always visible even after I have shrunk the size of the >>tick mark label. >Create a second date column in the worksheet, with the same date and >the format YY, and use both columns to make the date axis. This will >display correctly. Correction: will display correctly in 97. Having just looked at it in 2000, I see that the "improvement" that forces double-columned category ranges to look like those ugly Pivot Charts, with the combs cluttering up the space. So, plan B: go back to one column, format just the months you want with "mmmmm yy" (space, not hyphen) leaving the rest at "mmmmm". Then set Chart Options.. Axes to "Category", and set Format Axis to "Linked to source", then ensure that the months are packed too tightly to allow the year to appear in the same line. It will wrap down to the second line and appear as J 08 which is how you want it. SignatureDel Cotter NB Personal replies to this post will send email to del@branta.demon.co.uk, which goes to a spam folder-- please send your email to del3 instead. If I were having trouble with the labels, I'd hide the default labels, then plot a dummy series along the axis and assign data labels that achieve the look I need. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > On Thu, 28 Aug 2008, in microsoft.public.excel.charting, I said: >>e57 <tianhao.liu@gmail.com> said: [quoted text clipped - 26 lines] > > which is how you want it. |
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
|
©2010 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.