xy scatter plot question

[Guest]

I have xy scatter plot using dates for x axis. I change the min and max on
the x axis weekly. The problem is that the lines are "bleeding" over the y
axis. How do I make the lines go to the edge of the y axis but not over?
(make sense?). thanks

 

[Tushar Mehta]

I suspect that's how some MS programmer decided to indicate "there's data
back there that I cannot show."

One way to 'fix' this would be to add a rectangle to the chart from the
Drawing toolbar and position it properly. Kind of a pain but it works.

Another option would be to set the min. x value equal to that of the first
data point you want to show. If a data point is *on* the y-axis, XL will
not draw the "there's data there I cannot show you" bit.

I also checked with a Line chart but it doesn't help. It too includes the
extra bit of the line.

--
Regards,

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

 

[Jon Peltier]

I've noticed that the line stops at the edge of the plot area (the inside
plot area) if the series all have lines and no markers. Probably this
knowledge is not too helpful.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______