Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Macro read line graphs?
Is there a way macro can read line graphs?
I have a graph with temperature along the bottom, weight along the left side and in the the graph area there are several diagonal lines as pressure altitude. By entering the graph at Temperature going straight up into the graph to the correct pressure altitude then move left horizontally left and that will give you the answer (weight). -- WH99 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Macro read line graphs?
You may want to add a trend line to the graph and show equation. Then use
the equation to get the results you are looking for results Use Scatter chart rather than line chart Right click on any point on the graph and choose "Add Trand Line". find best results by getting an option that best resembles the actual data. Go to Options Tab - Display Equation on Chart. You can adjust the X - Intercept to get better reults. "WH99" wrote: Is there a way macro can read line graphs? I have a graph with temperature along the bottom, weight along the left side and in the the graph area there are several diagonal lines as pressure altitude. By entering the graph at Temperature going straight up into the graph to the correct pressure altitude then move left horizontally left and that will give you the answer (weight). -- WH99 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Macro read line graphs?
Thanks Joel.
I'll look at that. -- WH99 "Joel" wrote: You may want to add a trend line to the graph and show equation. Then use the equation to get the results you are looking for results Use Scatter chart rather than line chart Right click on any point on the graph and choose "Add Trand Line". find best results by getting an option that best resembles the actual data. Go to Options Tab - Display Equation on Chart. You can adjust the X - Intercept to get better reults. "WH99" wrote: Is there a way macro can read line graphs? I have a graph with temperature along the bottom, weight along the left side and in the the graph area there are several diagonal lines as pressure altitude. By entering the graph at Temperature going straight up into the graph to the correct pressure altitude then move left horizontally left and that will give you the answer (weight). -- WH99 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line graphs | Charts and Charting in Excel | |||
How do you select line or columns in "Line-Column on 2 axes" graphs? | Excel Discussion (Misc queries) | |||
Q about Line Graphs | Charts and Charting in Excel | |||
macro to make line graphs | Charts and Charting in Excel | |||
Line Graphs and Bar Graphs | Excel Discussion (Misc queries) |