If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
A scatter plot with a 2 column data source | SamB | Charts and Charting | 4 | August 23rd, 2007 11:44 PM |
Point labels in an Excel scatter plot to be associated text | k_thakur | Charts and Charting | 1 | August 15th, 2005 01:38 AM |
Post-versus Pre-surveys scatter plot chart | DSR | Charts and Charting | 1 | June 5th, 2005 12:54 PM |
Adding more source data to existing scatter plot | Tom | Charts and Charting | 1 | March 21st, 2005 10:03 PM |
Modification of Excel's Chart Tips in a Scatter Plot | George Elkins | Charts and Charting | 2 | November 14th, 2003 09:10 PM |