Excel should allow correlations of data so chart markers match up

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/comm...excel.charting

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" <[email protected]> wrote in message
news:[email protected]...
> 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!
>