View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta
 
Posts: n/a
Default xy scatter plot question

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

In article ,
says...
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