Home |
Search |
Today's Posts |
#1
|
|||
|
|||
a line between 2 points
Hello, I have graph that I update on a monthly basis, one point per month.
What I would like to do is to be able to draw a straight line from any month to the projection point that lies on the last column (12) of the graph. Can this be done without drawing it manually with a line from drawing toolbar? If this can not be done, is there a formula I could use to find each point? For sure I know the from and the to point. Thanks for your help |
#2
|
|||
|
|||
Simply plot a new line by adding a new series.
Mangesh "Daniel" wrote in message . .. Hello, I have graph that I update on a monthly basis, one point per month. What I would like to do is to be able to draw a straight line from any month to the projection point that lies on the last column (12) of the graph. Can this be done without drawing it manually with a line from drawing toolbar? If this can not be done, is there a formula I could use to find each point? For sure I know the from and the to point. Thanks for your help |
#3
|
|||
|
|||
A good idea. However, how do I get the values between point 2 and
point 12 to draw that line? Daniel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to add data points to a scatter plot with trend line | Charts and Charting in Excel | |||
Line Drawing Between Separated Data Points ? | Charts and Charting in Excel | |||
Formatting lines between data points in a line chart | Charts and Charting in Excel | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel |