Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
xy scatter plot question
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
xy scatter plot question
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/ _______ "Tushar Mehta" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Point labels in an Excel scatter plot to be associated text | Charts and Charting in Excel | |||
Zooming in on a Scatter Plot | Charts and Charting in Excel | |||
Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
scatter plot & label for a data point | Charts and Charting in Excel | |||
Fill area beneath a scatter plot | Charts and Charting in Excel |