MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Line Charts


Posted by Ray Deis on June 24, 2001 8:50 PM

I have a line chart with about 200 data points. Is it possible to set the number of markers that appear on the line so it is not so cluttered? For example, every fifth marker appears.


Posted by lurker on June 25, 2001 12:02 AM

Right click on the chart axis and go to Format axis/Scale tab. Play with the options there - you may be able to change it to what you want.