how do you use data from a chart in a spreadsheet or data chart?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I made an X Y scatter chart in Excel for a time depth display chart. I now
want to take that information and put it into a spreadsheet or data chart.
The XY chart only shows some crosspoints but I need the data chart to
automatically show me the points that are missing (not plotted on the XY
chart) I can enter the information into Excel but it leaves a tremendous
amount of blank points and I am not sure how to get them to automatically
fill in. It is not the same distance between each of the points. If anyone
can help me with this, I would be greatly appreciative.
 
It isn't really clear what you need. Do you want to interpolate to get values
between the points which are plotted?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top