View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Excel should allow correlations of data so chart markers match up

And how is Excel to know how to correlate the data? In a line chart, the
markers show up above their category, with no allowance for offsetting of
clustered series.

You can actually do this yourself using XY series instead of line series:

http://peltiertech.com/Excel/Charts/...olAndLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"TLC" wrote in message
...
When creating complex charts with columns and markers all markers show up
in
fromt of one column instead of being matched with the correct column. If
information could be correlated the markers could be line up with the
correct column which would make reading the chart easier!