Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with datapoints stack in XYScatter
hello,
Is there any way (using chart settings or VBA) to prevent the datalabels to stack (ontop of each other) in a XYScatter chart when the xValues and values of several datapoints coincide? Regards PO |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with datapoints stack in XYScatter
There is no built-in way that will prevent overlap of data labels. I've seen
a crude attempt that uses vba to move data labels out of each other's way, but I don't think the author has developed it further. It's a lot of work. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "PO" <h wrote in message ... hello, Is there any way (using chart settings or VBA) to prevent the datalabels to stack (ontop of each other) in a XYScatter chart when the xValues and values of several datapoints coincide? Regards PO |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stack columns | Excel Discussion (Misc queries) | |||
Tolerance Stack Excel Worksheet | Excel Discussion (Misc queries) | |||
Multiple columns in stack graph | Charts and Charting in Excel | |||
Stack Chart Legend Display | Charts and Charting in Excel | |||
excel stack tabs in groups, less scrolling L2R, hovering over gro. | Excel Discussion (Misc queries) |