Super User Stack Exchange
Super User Stack Exchange

Questions tagged [axis]

An axis is a reference line or plane used to denote referential measurements in relation to the data presented.

An axis (plural: axes) is normally used in to show the metrics of which the chart's data is being shown. Normally there are two or three axes, but this is not a rule. Common axes include time, weight, progress or direction.

59 questions
7
votes
2 answers

How do I create custom axes in Excel?

I'm creating a "histogram" and need the values of "frequency" to be displayed in ascending or descending order, which means that I need custom values for the x-axis. Instead of having: 1 2 3 4 5 6 7 I need to have this be values of cells: 85 93…
James Mertz
  • 26,224
  • 41
  • 111
  • 163
4
votes
2 answers

Get Excel to base tick marks on 0 instead of axis ends (with fixed maximum or minimum)

In other words, I want Excel to anchor the tick marks at 0. I am trying to get an axis that goes from -35 to 35, but with the ticks on multiples of 10: 30, 20, 10, 0, -10, -20, -30 I have set set a "fixed" (custom) major unit to 10, and with my…
A.M.
  • 997
  • 5
  • 16
  • 24
4
votes
3 answers

How to rename the values on Y Axis in Excel?

I'm trying to rename the values that are on my Y Axis on a chart in excel. Currently I have mapped various letters to number equivilants just to get it plotted, but would like now to have the letter equivalents on the Y axis (Think in terms of…
Irfy
  • 785
  • 2
  • 7
  • 10
4
votes
1 answer

How to make X axis into value axis instead of category axis in excel?

The problem I have is shown in the picture. Basicly I have data on the x axis, but the spacing between them is not uniform. So instead of puting '4780' in the correct place between '4000' and '5000' excel puts it in the same distance as all the…
József Kiss
  • 43
  • 1
  • 4
4
votes
3 answers

Manually adjust axis numbering on Excel chart

I want to adjust the X axis of my scatter diagram according to my diagram points in MS-Excel 2010. I have seen in some guides that I can change it by editing the "Axis Labels" in "Select Data". As you can see in the picture below, this button is not…
Hamed
  • 155
  • 1
  • 3
  • 8
3
votes
1 answer

How to create dynamic Scatter Plot/Matrix with labels and categories on both axis in Excel 2010?

Let us consider a following data set: Name | Age | Hair Color ----------------------------- John | Young | Brown Sophie | Old | Blond Adam | Mature| Blond Mark | Teen | Dark Jeremy | Old | Grey Alex | Young | Brown etc... Both…
user1581900
  • 135
  • 1
  • 1
  • 4
3
votes
0 answers

When I try to edit Y-axis limit on LibreOffice, the data in the chart disappears

Has anyone encountered such an issue? Am I missing something? When I choose axis limits manually from Right Click > Format Axis > Scale, the data in the chart disappears or gets hidden. I am using Column chart type. Software: LibreOffice Calc …
Dainius Stankevicius
  • 31
  • 4
3
votes
1 answer

Log scale axis labels amendment in Excel

I have a bar chart in Excel which I want to have in log10 scale. As the values are in % I get axis labels at 1%, 10%, and 100%. Is there a way to add labels at 20%, 30%, etc., I can't find a natural way to do it. Thanks!
ferros
  • 31
  • 1
  • 1
  • 2
2
votes
2 answers

showing negative excel axis without label

I have a graph with one negative value. I'd like to be able to Start the graph from the lowest value (in my example, -1) instead of 0 I'd like the major axis to still show every 10 units from 0, so since I'm starting at -1, I'd like to show at 0,…
Greeny12m
  • 33
  • 1
  • 4
2
votes
0 answers

Extract data from graph with curve as axis

I need to get data from a pretty simple yet not really common type of plot (graph). If you take a look at this image, you will notice that the Y axis is irrelevant and that curve has to take its place. The actual data I need is for each 'X'(l)…
vitalic
  • 21
  • 2
2
votes
1 answer

Excel 2010 line chart - how to have the x axis show mmm format (e.g. Jan Feb etc)

I have a table of data, with one row for each day of the year (1/1/2018 through to 31/12/2018). I want to show this on a line chart with the x axis labelled with the short text format of the dates, so Jan through Dec. I don't mind if the text is…
Wilskt
  • 121
  • 1
  • 2
1
vote
0 answers

Excel chart shows horizontal axis as the same value after pivot refresh

I have created a simple clustered column chart to display request volumes (y-axis) over time (x-axis, months). All of that is linked to a little CountIf table that sources data from a PivotTable (as the original raw data is too large and I would end…
Nick G
  • 11
  • 1
1
vote
1 answer

Word 2013 - Vertical axis title - text to display vertically

It seems that this is the correct StackExchange site for posting a simple Word2013 Q. If not, please let me know. I have searched everywhere and can not find an answer. In Word2013 I can not for the life of me find the option to make the primary…
Jabba021
  • 13
  • 4
1
vote
0 answers

Format Excel to Display Second Time Zone in Graph

I need to make my Y axis in a graph show the time in HH:MM (local) format as well as HH:MM +/- offset for another timezone. Form example: 09:00 EST 06:00 PST Is there some sort of custom format code I could use? Can I do somehow take the standard…
Tom
  • 11
  • 1
1
vote
1 answer

Display numbers twice on x axis in excel chart

I have following values that I would like to display on the X axis of my chart: 0,1,2,3,4,5,6,7,8,9,10,10,10,9,8,7,6,5,4,3,2,1,0 But my chart is displaying the values as 0,1,2,3,4,5,6,7,8,9,10,11,12... Is there a way to use the values as single…
user2452250
  • 123
  • 1
  • 5
1
2 3 4