Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Excel Plots Labels

  1. Jan 5, 2017 #1

    joshmccraney

    User Avatar
    Gold Member

    Hi PF!

    I'm plotting a log-log plot in excel, and each axis currently lists numbers like 1, 10, 100, 1000. What I would like is ##10^2,10^3##... etc. Any help would be awesome!
     
  2. jcsd
  3. Jan 5, 2017 #2

    phinds

    User Avatar
    Gold Member
    2016 Award

    Make a column of the 10**2, 10**3, etc using the superscript font option and then use that column for your labels.
     
  4. Jan 5, 2017 #3

    joshmccraney

    User Avatar
    Gold Member

    Thanks for responding phinds! Two problems though: first, let's say in the cell I type ##103## and then highlight the ##3## and superscript it to make ##10^3##. The moment I click on another cell it reverts to ##103##.

    Even if I could get this part to work, I don't know how to use that column for my labels. Any ideas?
     
  5. Jan 5, 2017 #4

    phinds

    User Avatar
    Gold Member
    2016 Award

    Damn. I see what you mean. I THOUGHT I had done this before but maybe not.

    There again, I feel like it's something I've done in the past but I'm coming up blank right now.

    Guess I'm no help at all.

    HA! --- Got it on the superscript. You can force the cell to text mode by starting with a single quote and then it will keep the superscript.

    OK, I've done half the job, you do the other half and tell us all how. :smile:

    Hmmmm ... I coerced it into using the superscripted text cells as axis labels by just using the axis lable edit but it threw away the superscripting. Maybe it can't be done.
     
  6. Jan 5, 2017 #5

    joshmccraney

    User Avatar
    Gold Member

    Thanks for all the help! I couldn't figure it out so I ended up importing the graph into PowerPoint and manually placing the axis labels. Since PowerPoint forces images to be aligned, this shockingly worked out very well!
     
  7. Jan 5, 2017 #6

    phinds

    User Avatar
    Gold Member
    2016 Award

    Good job.
     
  8. Jan 5, 2017 #7

    joshmccraney

    User Avatar
    Gold Member

    Thanks! It felt really ghetto but whatevero0)
     
  9. Jan 6, 2017 #8

    phinds

    User Avatar
    Gold Member
    2016 Award

    Hey, if it works, it works.
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?
Draft saved Draft deleted