| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I get a value of a calculated point on an excel line chart?
I created a line chart in Excel and I wanted to find out if there was a way
to find out the value on any particular point on the line (not one of the values I entered to create the line, but one in between)? |
|
#2
|
|||
|
|||
|
On a Line or an XY chart?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "klc6778" wrote in message ... I created a line chart in Excel and I wanted to find out if there was a way to find out the value on any particular point on the line (not one of the values I entered to create the line, but one in between)? |
|
#3
|
|||
|
|||
|
It is a line chart with x-y axies....I'm not sure if that answers your
question... "Bernard Liengme" wrote: On a Line or an XY chart? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "klc6778" wrote in message ... I created a line chart in Excel and I wanted to find out if there was a way to find out the value on any particular point on the line (not one of the values I entered to create the line, but one in between)? |
|
#4
|
|||
|
|||
|
If it is a "LINE" chart, then your x-y values are ignored in favor of
1,2,3, ... (though Excel will use your values as labels to further confuse the issue). You probably intended what is done by an "X-Y (Scatter)", which appears to use a 4-point Bezier curve for a smoothed fit. http://groups.google.com/group/micro...6e73b9504082f? Unfortunately, the address where Brian Murphy posted the algorithm is no longer valid. Cubic splines will often approximate the smoothed Excel curve, and David Braden posted an algorithm for cubic splines in these newsgroups, which should be accessible via Google archives. Jerry klc6778 wrote: It is a line chart with x-y axies....I'm not sure if that answers your question... "Bernard Liengme" wrote: On a Line or an XY chart? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "klc6778" wrote in message ... I created a line chart in Excel and I wanted to find out if there was a way to find out the value on any particular point on the line (not one of the values I entered to create the line, but one in between)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated Item | Excel Worksheet Functions | |||
| Calculated field in pivot table | Excel Discussion (Misc queries) | |||
| decimal point override does not work | Excel Discussion (Misc queries) | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
| Excel 2002 -> Problem with calculated fields in Pivottable | Excel Discussion (Misc queries) | |||
Hybrid Mode
