Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change all data markers (excel chart) to triangles in one command
There must be some command which tells a new chart to randomize colors and symbols- this can look junky. I would llike to find a way to change all symbols simultaneouly to various shapes until I find what makes the chart most read-able. thankyou |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change all data markers (excel chart) to triangles in one command
It's not a single command. You need to loop through the series in a chart
and apply colors and symbols as you see fit. This procedure cycles among the marker shapes in a line or XY chart: Sub RotateMarkers() Dim srs As Series Dim NewMarker As Long Select Case ActiveChart.SeriesCollection(1).MarkerStyle Case xlMarkerStyleCircle NewMarker = xlMarkerStyleDiamond Case xlMarkerStyleDiamond NewMarker = xlMarkerStyleSquare Case xlMarkerStyleSquare NewMarker = xlMarkerStyleTriangle Case xlMarkerStyleTriangle NewMarker = xlMarkerStylePlus Case xlMarkerStylePlus NewMarker = xlMarkerStyleStar Case xlMarkerStyleStar NewMarker = xlMarkerStyleX Case xlMarkerStyleX NewMarker = xlMarkerStyleCircle Case Else NewMarker = xlMarkerStyleCircle End Select For Each srs In ActiveChart.SeriesCollection srs.MarkerStyle = NewMarker Next End Sub - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "jawn" wrote in message ... There must be some command which tells a new chart to randomize colors and symbols- this can look junky. I would llike to find a way to change all symbols simultaneouly to various shapes until I find what makes the chart most read-able. thankyou |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Range Mess | Charts and Charting in Excel | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
How to prevent Excel 2003 from automatically change chart type | Charts and Charting in Excel | |||
Fan charts | Charts and Charting in Excel | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |