Building a semi-logarithmic chart in EXCEL

Solved
danobriga Posted messages 1 Status Member -  
 Danobriga -
Hello,
I am finalizing the preparation for my thesis defense and I need to transform a port traffic graph over 160 years into a semi-logarithmic graph. I want to make this type of graph because my traffic has multiplied by 9 over 160 years.
Anne mentioned that you just need to double-click on the axis you want to make logarithmic, and the "scale" section appears, where you can find "logarithmic." By clicking on it, you can transform the axis scale and then build a semi-logarithmic graph. Unfortunately, I couldn't find this "scale" section by double-clicking on the concerned axis, and I am unable to create the graph I want. Could someone please guide me on the steps to follow? I have EXCEL 2007, not 2010. Thank you in advance.
Danobriga

2 answers

  1. ccm81 Posted messages 11033 Status Member 2 434
     
    Hello

    In principle, right-click on the axis / Axis format and Scale pane

    Regards
    2
    1. Danobriga
       
      Hello,
      Thank you for your response; I found and resolved my issue.
      Best regards
      François
      0