 |
 | 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 2005new marker styles
A workmate with the same version of Excel has a different set of data markers available. I found the article below that says alternate patterns and styles are available - but didn't say where - can anyone help? This article was previously published under Q97589 SUMMARY Data markers on xy (scatter), line, and radar charts have a fixed size in all versions of Microsoft Excel (although alternate patterns and styles are available). However, there is a technique you can use to replace the current data markers with objects of a different size.  SignatureLis This is rather old information: REFERENCES "Microsoft Excel User's Guide 1," version 4.0, Pages 481-485 "Microsoft Excel User's Guide," version 3.0, Pages 486-491 The latest version of Excel is Excel 2003, or Excel 11.0. If you double click on a series and click on the Patterns tab, you have the option to change the size of the data marker. The default markers are the same in all "modern" versions of Excel (since '97), but the technique offered in the article you cite can be used to use any shape as a series' markers: - draw a shape or otherwise acquire a potential marker - copy the marker - select an individual point or an entire series - use Paste from the Edit menu, or Ctrl+V - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ > A workmate with the same version of Excel has a different set of data markers > available. I found the article below that says alternate patterns and styles [quoted text clipped - 6 lines] > available). However, there is a technique you can use to replace the current > data markers with objects of a different size. SignatureLis > This is rather old information: > [quoted text clipped - 34 lines] > > available). However, there is a technique you can use to replace the current > > data markers with objects of a different size. Hi Jon, The problem I have is that on one machine the markers are a Circle and on another machine they are shown as a circle with a cross thru it. Both machines have the same version of Excel. and all other variables are set the same. However I have solved (sort of) the problem by setting the forground color to 'no color' on the graph and the machines showing the cross just have it as a circle now. thank you for your time. SignatureLis > This is rather old information: > [quoted text clipped - 34 lines] > > available). However, there is a technique you can use to replace the current > > data markers with objects of a different size. |
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
|
©2008 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.