If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combined bar and line chart (two Y axis) how to make excel know which data goes where | Bugjam1999 | Charts and Charting | 2 | September 22nd, 2005 11:57 AM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Help with data not getting plotted | Scott Ehrlich | General Discussion | 2 | January 25th, 2005 05:17 AM |
Excel 2000 "Dead" Chart Links | Phoenix | Charts and Charting | 4 | September 16th, 2004 07:51 PM |
Excel Worksheets | Richard | General Discussion | 2 | July 8th, 2004 04:34 AM |