Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Markers making things too busy
I have a scatter chart with data points connected by lines. I would like to
put in point markers, but the data is too busy. Is there any way to have Excel put in markers for only 1 out of every 5 charted points? Libby |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Markers making things too busy
Hi,
The simplest way to do this is to plot 2 series. The first series plots all points and is just the connecting line with no data markers. The 2nd series is used to just display markers. and is based on a subset of the original data. Assuming you x and y data is in column A and B you could use this formula in C to display every 5th marker =IF(MOD(ROW()-1,5)=0,B1,NA()) Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Libby" wrote in message ... I have a scatter chart with data points connected by lines. I would like to put in point markers, but the data is too busy. Is there any way to have Excel put in markers for only 1 out of every 5 charted points? Libby |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting from Quickbooks - "busy program" | Excel Discussion (Misc queries) | |||
how can I avoid "server busy" message during ole automation | Excel Discussion (Misc queries) | |||
SumProduct making things work slow | Excel Worksheet Functions | |||
Too many markers on line chart makes it a thick line and individual markers cannot be seen | Excel Discussion (Misc queries) | |||
Keeping my computer busy | Excel Discussion (Misc queries) |