Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a request to chart data where I only want to display a marker every n
points, but still see the marker in the Legend. I can do it by setting the MarkerStyle to a value, then go through every point in the series and change it's markerstyle to xlNone. However, when there are 1000's of datapoints per series, this takes a long time. I can set the MarkerStyle to xlNone, then go through setting every nth point to a marker, but then the MarkerStyle doesn't show up in the legend. I can't seem to set the MarkerStyle in the LegendKey without affecting all the points in a series. Does anyone have a way I could see the Marker in the Legend Key, but only have the marker visible for every Nth point, without having to iterate through every point in every series? Thanks, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 row markers | Excel Worksheet Functions | |||
Excel: using data labels as markers | Charts and Charting in Excel | |||
Excel Data Markers, Limit Qty | Charts and Charting in Excel | |||
Too many markers on line chart makes it a thick line and individual markers cannot be seen | Excel Discussion (Misc queries) | |||
How do I get Excel 4.0 style markers in Excel 2003? | Charts and Charting in Excel |