How to show reciprocal values for 6 measurments in a chart

  • Thread starter Thread starter mitch200
  • Start date Start date
M

mitch200

Hello!


I have a problem:
First i explain on what am i working.
With GPS were made several measurments on the same track at differen
hours.
Output data of GPS transfered to excel is in meters and speed for eac
section. I sumed up the single sections in meters in a third coloumn
Because the measurment was taken on the same track all sumed up lengt
sections have approximatly the same value, but not the same interva
values. In the chart i have to show all the speeds with appertaine
length for 6 measurments in a day. in the source data the chart take
one or max. two x axis labels.
One more thing. Is it possible(quicker) to make 6 individual chart
and then overlay them
 
Mitch -

As I explained in response to your email, you should use an XY Scatter chart if you
X values are numerical. Also, you should arrange your data with charting in mind,
with X data in columns to the left of the Y data. Finally, only a masochist would
prefer making several separate charts and overlaying them, because it is next to
impossible to manage the slight differences in plot area position without using VBA.
Especially when rearranging your data makes plotting several scatter chart series on
a chart very easy.

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