LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 66
Default Excel 2003 Markers

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 row markers VJS Excel Worksheet Functions 1 November 23rd 09 05:59 PM
Excel: using data labels as markers Velson Horie Charts and Charting in Excel 4 April 27th 09 09:49 PM
Excel Data Markers, Limit Qty Jeko Charts and Charting in Excel 3 December 1st 06 03:43 AM
Too many markers on line chart makes it a thick line and individual markers cannot be seen denzel Excel Discussion (Misc queries) 2 August 2nd 06 04:06 PM
How do I get Excel 4.0 style markers in Excel 2003? mdmiller55 Charts and Charting in Excel 1 July 25th 05 08:34 AM


All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"