View original (French)

Excel formula to edit bike circuit profile

Mots croisés Posted messages 3059 Registration date   Status Member Last intervention   -  
 Dr Fu -
Hello,

If someone could tell me how to create bike route profiles in Excel, in order to reproduce the route's profile (distance, altitude). I'm not looking for ready-made software. I want to know the formula(s) to edit it myself. I've tried to do this with help on charts, but the proportion is not respected regarding the distance in relation to the elevation change. I hope I can be understood.

Thank you

JC
Configuration: Windows XP Firefox 3.0.8

5 answers

  1. Albert
     
    I have something that might help you:

    If I understood correctly, you have altitude on the y-axis and kilometer distance of the altitude recorded on the x-axis.

    1) Right-click on the chart, select "Chart Options"
    2) In this window, select the "Axes" tab and check the "Chronological" box under "X-axis" and then confirm
    3) Right-click on the x-axis and select "Format Axis"
    4) In the new window, in the "Number" tab, choose the "Number" category.

    This automatically inserts values between your values to achieve a proportional x-axis.

    To fine-tune, you can right-click on your curve and in the window under the options tab, check "Projection Line"; this will draw a vertical line only for the data in your table (the entered distance).

    Phew!
    I hope this meets your needs.

    Talk to you later.
    2
    1. Mots croisés Posted messages 3059 Registration date   Status Member Last intervention   113
       
      Thank you Albert for this information. As soon as I've checked, I'll let you know what it is.

      See you soon

      JC
      0
    2. Dr Fu
       
      Thank you, it works perfectly.
      0
  2. Polux31 Posted messages 7219 Status Member 1 204
     
    Lost...

    I didn't understand anything... Ô_o

    --
    “What is well conceived is clearly expressed, and the words to say it come easily.”
    Nicolas Boileau
    0
    1. Mots croisés Posted messages 3059 Registration date   Status Member Last intervention   113
       
      You didn't understand anything, Polux, but maybe others did (smile)))))))). I'm teasing you. Actually, I'm not sure how to explain what I want. I'll try again.
      I practice cycling. And, with Excel, I want to be able to display the profile of my rides. That is to say, with a graph showing the different altitude points, ascents, and descents. Just like you see in cycling books when they explain the mountain stages of the Tour de France. I've already tried to practice on a graph, but the elevation change is not proportional to the distance. At this point, I don't know how to explain what I mean. Hopefully, this time you understand. I am convinced, and I'm even sure there is a formula in Excel.

      Thank you

      JC
      0
  3. Mots croisés Posted messages 3059 Registration date   Status Member Last intervention   113
     
    Hi Albert

    Actually, my Excel table would look like this. From there, I select the entire dataset and create an area chart. When I clicked "timeline," the waypoints disappear, giving way to numbers. And I don’t understand what you mean by "right-click on the curve."
    I’m using Excel 2003.

    Thanks

    JC

    PS: If someone else is reading this. What I actually want is for the distance proportion on the generated chart to be relative to the elevation. Because in the charts I’ve made so far, whether I display 10km or 100km, the space between two points is always the same.

    Km Altitude
    annecy 448
    menthon 10 500
    col forclaz 20 1150
    vesonne 9 450
    faverges 5 500
    col tamié 10 917
    albertville 15 300
    0
  4. Albert
     
    What I sent you is Excel 2003.
    But I thought you were making a curve and not areas, so right-clicking on the curve doesn't work. First switch to a curve for the right-click, then change the chart type to area.

    Moreover, if you have names (text) on the x-axis, it won't work! You need numerical values (the mileage).

    Can you attach your file? via cjoint.com

    1+
    0
    1. Mots croisés Posted messages 3059 Registration date   Status Member Last intervention   113
       
      cjoint.com won't display Albert

      If you had signed up, I could have sent you my Excel doc.

      Actually, I didn't think the data I displayed would be positioned as it is now.
      Let's say I created 3 columns. One for the places, one for the distances, and another for the altitude. A classic format for this table.

      I switched from an area chart to a line chart as you recommended. But I don't understand and can't find: ""right-click on the curve"". Sorry, I'm not very skilled )))))).

      Maybe there's a formula to enter to achieve the proportions, I don't know. But I'm not losing hope.

      Thanks

      JC
      0
  6. Anonymous user
     
    I signed up.

    I couldn't make a graph (line or area) that displays altitude in relation to distance and shows the names of places on the x-axis!

    Sorry, I keep working on it, but no guarantees.
    0
    1. DATABIKE
       
      Hello,
      You will find Excel applications on the website www.databike.com, on the download page.
      Best regards,
      0