LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Too many markers on line chart makes it a thick line and individual markers cannot be seen

I have lots of data to be plotted and when I choose a marker to be
displayed, the resultant line just looks like a thicker line. You can't
individually pick out the marker being used. Without messing with the input
data, is there any way to get Excel to place a marker every 10th or 20th
data point instead of every data point?

I still want the line to plot the entire data. And I don't want to have to
manipulate my source data. If I only plot every 10th data point, I may miss
peaks that occur between the 10th points. And it's too cumbersome to pick
the data by hand out of the hundreds of data points.

I want to continue to use markers instead of colors or dashed lines to
differential my graphed lines.

Smaller symbols won't help since the data is so closely plotted together.

Is there some easy solution to this?

Thanks.


 
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 Line Chart help Springsteen Excel Discussion (Misc queries) 0 August 1st 06 04:50 PM
Change individual series from bar to line CLK-user1 Charts and Charting in Excel 1 July 21st 06 12:56 PM
Can a combo chart plot 4 variables? (3 bars,1 line) [email protected] Charts and Charting in Excel 1 June 20th 06 01:41 PM
Line Chart - 2 Aurora Charts and Charting in Excel 1 March 8th 06 09:22 PM
XY Scatter Legend when Edit Individual Markers John Charts and Charting in Excel 6 June 13th 05 03:06 PM


All times are GMT +1. The time now is 03:31 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"