| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
x-y Line Graph question
I have a line graph. X is dates and Y is numeric data. I am plotting
12/1/2005 through 1/30/2006. The problems is my series does not start at the "left most" point of 12/1/2005, it is shifted slightly. And the line does not end at the "right most" point of 1/30/2006. Any ideas will be appreciated. thanks! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
x-y Line Graph question
XL has two distinct chart types even though they look similar, the XY
Scatter chart and the Line chart. There is no XY Line graph. I believe you have a Line graph. Double-click the x-axis and from the Scale tab uncheck the 'Value (Y) axis crosses between dates' checkbox. Alternatively, if the scale tab has fields for Min. / Max. values you may want to adjust those. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have a line graph. X is dates and Y is numeric data. I am plotting 12/1/2005 through 1/30/2006. The problems is my series does not start at the "left most" point of 12/1/2005, it is shifted slightly. And the line does not end at the "right most" point of 1/30/2006. Any ideas will be appreciated. thanks! |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
x-y Line Graph question
this works . thanks for the tip
"Tushar Mehta" wrote: XL has two distinct chart types even though they look similar, the XY Scatter chart and the Line chart. There is no XY Line graph. I believe you have a Line graph. Double-click the x-axis and from the Scale tab uncheck the 'Value (Y) axis crosses between dates' checkbox. Alternatively, if the scale tab has fields for Min. / Max. values you may want to adjust those. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have a line graph. X is dates and Y is numeric data. I am plotting 12/1/2005 through 1/30/2006. The problems is my series does not start at the "left most" point of 12/1/2005, it is shifted slightly. And the line does not end at the "right most" point of 1/30/2006. Any ideas will be appreciated. thanks! |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
x-y Line Graph question
In article ,
says... this works . thanks for the tip You are welcome. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bar graph and line graph overlayed | Charts and Charting in Excel | |||
| Line Graph Help | Charts and Charting in Excel | |||
| Custom Line Graph on 2 axes help | Charts and Charting in Excel | |||
| Line and Column Graph | Charts and Charting in Excel | |||
| Can you have a vertical line graph in Excel 2003 | Charts and Charting in Excel | |||
Linear Mode
