ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Excel should allow correlations of data so chart markers match up (https://www.excelbanter.com/charts-charting-excel/104115-excel-should-allow-correlations-data-so-chart-markers-match-up.html)

TLC

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

Jon Peltier

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!






All times are GMT +1. The time now is 09:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com