View Single Post
  #7   Report Post  
Tushar Mehta
 
Posts: n/a
Default

Hi Philip,

Yes, I noted that problem with the trendline boxes in my first post.

As to whether MS will fix the problem, my guess is "doubtful." After
all, it hasn't fixed the problem introduced in XL2002 where one cannot
format (delete) just one segment of a line chart. By comparison, this
is so esoteric that I doubt it would even be considered. Then, of
course, MS might just prove me wrong. {g}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hi Tushar

Take also a look at the trendlines. The boxes which display the equations
can be moved when the lines look okey. The boxes can for some reason not be
moved when the lines are plotted wrong. They stay fixed in the upper right
corner no matter what you do.

Yep, some crappy code they put behind that drawing routine.

Do you think MS will correct this problem in a future release?

-----
Philip

"Tushar Mehta" wrote:

Hi Brian,

Thanks for your comments. I guess this is yet another 'limit' on how
well XL's charting module handles different user requirements. {g}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

Tushar,

This indeed is very strange. I played around with the sample file, and
observed many quirky things. Enough to drive you nuts.

My guess is that what's behind the strange behavior are the points that
are actually far off the plot because of the manually set axis scales.

When I developed the bezier code I noticed that excel tries to get
clever when plotted points are off scale. Especially when smooth
curves were turned on. I was expecting that "smooth curves" was
involved here, as well. But it's not.

Brian



--
xlrotor
------------------------------------------------------------------------
Posted via
http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1411111.html