Building a semi-logarithmic chart in EXCEL
Solved
danobriga
Posted messages
1
Status
Membre
-
Danobriga -
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
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
Thank you for your response; I found and resolved my issue.
Best regards
François