Enhance Your Excel Plots with Custom Labels for Optimal Data Visualization

  • Thread starter Thread starter member 428835
  • Start date Start date
  • Tags Tags
    Excel Plots
Click For Summary

Discussion Overview

The discussion revolves around customizing axis labels in Excel for a log-log plot, specifically the challenge of displaying labels in scientific notation with superscripts. Participants explore various methods to achieve this, including the use of text formatting and alternative software solutions.

Discussion Character

  • Technical explanation
  • Exploratory
  • Debate/contested

Main Points Raised

  • One participant seeks assistance in formatting axis labels in Excel to display numbers like 10^2, 10^3 instead of standard numeric representations.
  • Another participant suggests creating a separate column with superscripted text for the labels.
  • A participant expresses difficulty in maintaining the superscript formatting when switching cells in Excel.
  • There is a realization that forcing the cell into text mode can preserve the superscript, but challenges remain with using these cells as axis labels.
  • One participant shares a workaround by importing the graph into PowerPoint and manually adjusting the labels, which they found effective despite feeling unsatisfactory.

Areas of Agreement / Disagreement

Participants do not reach a consensus on a definitive method to achieve the desired label formatting in Excel, with multiple approaches discussed and some unresolved challenges remaining.

Contextual Notes

Limitations include the inability to retain superscript formatting when using Excel's axis label editing feature and the reliance on alternative software for a satisfactory solution.

member 428835
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!
 
Physics news on Phys.org
Make a column of the 10**2, 10**3, etc using the superscript font option and then use that column for your labels.
 
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?
 
joshmccraney said:
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.
 
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!
 
joshmccraney said:
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.
 
phinds said:
Good job.
Thanks! It felt really ghetto but whatevero0)
 
joshmccraney said:
Thanks! It felt really ghetto but whatevero0)
Hey, if it works, it works.
 

Similar threads

MATLAB How to plot flow data from an orifice in MATLAB without overlapping the plots?
  • · Replies 2 ·
Replies
2
Views
3K
MATLAB MATLAB-Plot two sets of data on the same graph with custom increments
  • · Replies 1 ·
Replies
1
Views
4K
How can you modify Python code for effective graph plotting?
  • · Replies 7 ·
Replies
7
Views
3K
Does Software Exist for Symbolic Plotting with Custom Axis Labels?
  • · Replies 3 ·
Replies
3
Views
2K
MATLAB Changing the tick labels in MATLAB for each loop iteration
  • · Replies 2 ·
Replies
2
Views
4K
Building a Plot with Array Data: A Challenge
  • · Replies 9 ·
Replies
9
Views
4K
Waterfall plot of an PMSM
  • · Replies 1 ·
Replies
1
Views
1K
MATLAB MATLAB Code For Analyzing Experimental Data
  • · Replies 12 ·
Replies
12
Views
4K
Mathematica Plotting a family of curves in mathematica
  • · Replies 4 ·
Replies
4
Views
11K
Data analysis by guessing, checking and fixing
  • · Replies 5 ·
Replies
5
Views
4K