Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
PO
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
stack columns Wan Excel Discussion (Misc queries) 1 December 26th 05 05:22 AM
Tolerance Stack Excel Worksheet MTUSNOW Excel Discussion (Misc queries) 0 September 7th 05 11:05 PM
Multiple columns in stack graph Amanda Charts and Charting in Excel 8 August 6th 05 02:15 AM
Stack Chart Legend Display John Charts and Charting in Excel 1 May 15th 05 03:44 AM
excel stack tabs in groups, less scrolling L2R, hovering over gro. Stephen Robb Excel Discussion (Misc queries) 1 February 18th 05 11:48 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"