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

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.
 
J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numbering Data Points on Chart 2
XY Scatter Chart Markers 3
Remove Connnecting Lines from Line Chart? 2
time scale proportional using a column chart - not just for scatte 4
To plot 3 series each with 90000 data in single Line or XY chart. 4
Excel 2007: Default Chart Template 2
How do I disable automatic chart creation in Excel? 1
How do I adjust marker spacing in Excel scatter plot? 1

Top