Microsoft KB Archive/97589

= How to Resize Data Markers on Charts =

Article ID: 97589

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 98 for Macintosh

-



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.



MORE INFORMATION
To replace the existing data markers with different objects, follow these steps:


 * 1) Create a chart.
 * 2) Create the object you want to use as your data marker on your chart. You can use the drawing tools on the Drawing toolbar to do this.
 * 3) Click the object and click Copy on the Edit menu.
 * 4) If the chart is embedded on the worksheet, activate the chart by double-clicking it. If the chart is in a chart file, activate it by clicking the name of the chart on the Window menu.
 * 5) Select the series you want to change by selecting the data marker on the chart. On the Edit menu, click Paste.

The selected data marker and series are replaced with the copied object.

NOTE: The objects you create can be any size or pattern, including text edit boxes. The chart legend is automatically updated to show the new data marker. Note also that the above method does not work for line or radar charts that do not have data markers.

