Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Usually, I have to chart alot of data. I cannot really use color to
distinguish the line and the line styles leave alot to be desired when the points are close together. Therefore, I use the symbols to better distinguish the data series. However, with alot of data the symbols make the lines just appear fat, again making it difficult to distinguish the line. Therefore, I loop through the points and set the individual point markers at a different frequency for each series. This works great. However, the legend doesn't display the markers. The first point on every data series always has a marker. Is there a way to change what the Legend displays wrt symbols? Because I do the symbol addition programmatically the first data series on a chart always has the same look. However, when there is only one series on the chart the legend changes to show a list of xlCategory values for the points with the line and symbol style next to them. I need the legend because the titles are generic for a group of about 50 charts. Is there a way to prevent this behavior? XMGR is sooooo much easier at plotting alot of data. Thanks, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) |