Excel Plots Labels

  • #1
joshmccraney
Gold Member
1,955
102
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!
 

Answers and Replies

  • #2
phinds
Science Advisor
Insights Author
Gold Member
2019 Award
16,348
6,542
Make a column of the 10**2, 10**3, etc using the superscript font option and then use that column for your labels.
 
  • #3
joshmccraney
Gold Member
1,955
102
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?
 
  • #4
phinds
Science Advisor
Insights Author
Gold Member
2019 Award
16,348
6,542
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##.
Damn. I see what you mean. I THOUGHT I had done this before but maybe not.

Even if I could get this part to work, I don't know how to use that column for my labels. Any ideas?
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.
 
  • #5
joshmccraney
Gold Member
1,955
102
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!
 
  • #6
phinds
Science Advisor
Insights Author
Gold Member
2019 Award
16,348
6,542
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!
Good job.
 
  • #7
joshmccraney
Gold Member
1,955
102
Good job.
Thanks! It felt really ghetto but whatevero0)
 
  • #8
phinds
Science Advisor
Insights Author
Gold Member
2019 Award
16,348
6,542
Thanks! It felt really ghetto but whatevero0)
Hey, if it works, it works.
 

Related Threads on Excel Plots Labels

  • Last Post
Replies
2
Views
661
  • Last Post
Replies
2
Views
638
Replies
1
Views
9K
  • Last Post
Replies
3
Views
990
  • Last Post
Replies
1
Views
2K
Replies
1
Views
2K
Replies
2
Views
4K
  • Last Post
Replies
1
Views
2K
Replies
6
Views
7K
Top