Excel should allow correlations of data so chart markers match up

[Guest]

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!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...576acc9a4d&dg=microsoft.public.excel.charting

 

[Jon Peltier]

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/ClusterColAndLine.html

- Jon