Home |
Search |
Today's Posts |
#1
|
|||
|
|||
referencing lines and series points
what is the VBA code for referencing to individual points in a line on a line graph? i would like to create a macro to change indiviual points' shapes and the color or the lines in between them to different colors depending on different parameters. is this possible? -- medicenpringles ------------------------------------------------------------------------ medicenpringles's Profile: http://www.excelforum.com/member.php...o&userid=16458 View this thread: http://www.excelforum.com/showthread...hreadid=391019 |
#2
|
|||
|
|||
Hi,
The Macro Recorder is useful for tasks like this. Giving you an insight into the objects and properties needed. Sub Macro2() ' ' change the line between points and 4 to red ' ActiveChart.SeriesCollection(1).Select ActiveChart.SeriesCollection(1).Points(4).Select With Selection.Border .ColorIndex = 3 .Weight = xlThin .LineStyle = xlContinuous End With ' ' change marker to red circle black border size 10 ' With Selection .MarkerBackgroundColorIndex = 3 .MarkerForegroundColorIndex = 1 .MarkerStyle = xlCircle .MarkerSize = 10 .Shadow = False End With ActiveChart.PlotArea.Select End Sub Cheers Andy medicenpringles wrote: what is the VBA code for referencing to individual points in a line on a line graph? i would like to create a macro to change indiviual points' shapes and the color or the lines in between them to different colors depending on different parameters. is this possible? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change a data series from bars to lines in an Excel char. | Charts and Charting in Excel | |||
Chart REALLY needs to support more than 255 data series | Charts and Charting in Excel | |||
determining (and displaying) slopes that exceed x | Charts and Charting in Excel | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
Excell Chart-how do I change all the lines and points without cha. | Charts and Charting in Excel |