Questions tagged [axis]
An axis is a reference line or plane used to denote referential measurements in relation to the data presented.
57
questions
0
votes
0
answers
37
views
Horizental axis label disappears when changed to log scale
In excel, i tried to draw the forest plot using risk ratio and confidence interval. However, when i change the horizontal axis lab to scale, scale labels disappear? What could be wrong here?
I have ...
0
votes
1
answer
520
views
Line Chart vertical grid lines only for aggregated values (days, instead of hours)
I have two columns: day of week, hours (for each day) and number of things occurring on each hour of a specific day of week.
Below an example with first two days:
I want to plot these data as a line ...
- 103
0
votes
1
answer
2k
views
Forcing Excel to show only whole numbers on a Y axis
I have a chart that is only a Y axis with minimum value of 81.87 and max value of 91.87. Looks like this:
I'd like to modify it in such way that only whole numbers are displayed (82, 83, 84 and so on)...
- 101
0
votes
2
answers
87
views
Why is X-axis not scaling to the data?
(Novice and almost entirely self-taught, but can't seem to find anything here that addresses my issue)
I am adding a chart to a spreadsheet that tracks outstanding tasks for each day by type. I am ...
- 101
0
votes
1
answer
404
views
How to remove non whole-number notations from excel histogram?
I would like to remove the non-whole number values from the y-axis, and I would like to let only the red cycled whole numbers.
There is no option to set the main tick to 1.
- 3
0
votes
2
answers
330
views
Start an Excel Axis at uneven value (e.g. 3) compared to labels (e.g. 5/10/15)
When I use an interval on an Excel x-axis for the labels of 5, Excel will use 0, 5, 10 for the labels.
When the start value is 3, Excel will use 3, 8, 13 for the labels.
How can I continue to use 5, ...
- 507
0
votes
0
answers
62
views
Excel 2013 Pivot Chart: wrong day-count on y-axis
I'm making this pivot-chart where the orange series shows the average count of days (gg) with hh:mm:ss part.
Now, as you can see on the picture the pop-up shows the correct value (00gg 23:53:37), but ...
- 1
1
vote
1
answer
987
views
Excel chart, change axis tick's positions to specific integer values
I'm trying to move the position of all axis ticks to integer values while trying to keep the real scale (min and max values) of the axis as decimals.
The current position of the ticks are: 6.8, 7.8, 8....
- 11
0
votes
1
answer
22
views
How to include more dates on my x axis
I’m having issue to include additional dates on my x axis.
Usually I’d select data, edit my horizontal axis label to include more dates. (2nd pic) But it’s not showing up on my graph. (1st pic) I also ...
0
votes
1
answer
531
views
Specific x-axis gaps or bounds
I need help with this specific situation. I have a table with values between 0 - 115 and i want to display them with a chart like in the picture below.
Picture1
The thing is that on chart i want the ...
0
votes
2
answers
3k
views
Datetime X-axis in Excel with proportional distances between value points
There are countless of Stack posts about how to create a datetime X-axis in Excel (change from Number to Text in the axis formatting) but this only solves the display of the text. I would like to have ...
- 553
1
vote
0
answers
372
views
Excel Line chart X-axis does not display the right date/time
I am trying to plot a line chart in Excel , the x-axis is changing the year value significantly and I cannot figure out why.
It is taking my data from 2017 and adding over 100 years to it. For the ...
- 19
1
vote
0
answers
165
views
In Excel scatterplot bubble charts, how do we display the year major tick as an "start of year period" rather than an "end of year period"?
I am trying to build a scatterplot chart visualization of instructor scores for a series of classes to show performance metrics, relative class size (size of bubble), plotted over time. Classes are ...
- 119
0
votes
1
answer
116
views
Excel Pivot Chart 2013 Multiple y-axis
I used to use the pivot chart function in Access to overlay multiple sets of process variables to help understand relationships within my manufacturing process. MS removed this function so now I'm ...
- 1
0
votes
0
answers
879
views
How does Excel determine the min / max of the Y Axis?
As the title asks, how does Excel set the min max for the Y axis.
I have a line chart with a series plotted across 36 points, the values range from 457 - 514.
Whilst the Y-axis min/max are set to ...
- 7,337
0
votes
1
answer
1k
views
Automatic formatting of axis in Excel stacked bar chart to start at start date?
I have used this blog https://peltiertech.com/excel-gantt-charts/#comment-1455520 to create a Gantt chart in Excel that acts as a template for others to input their information (i.e. tasks, start ...
- 1
0
votes
2
answers
3k
views
Excel: Display two currencies on graph axis
I am trying to display two currencies on the y-axis. I do not want two y-axis. Essentially, I am presenting to two audiences; some from South Africa (hence Rand), and some from the Netherlands (hence ...
- 3
-3
votes
1
answer
400
views
Characters in any game start moving automatically
Characters in games are running automatically. When I start GTA the character runs forward. When I start Adventure time the camera rotates automatically. Even when I start Unity, start the survival ...
- 15
3
votes
0
answers
483
views
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 ...
0
votes
0
answers
1k
views
Can I calibrate mouse axis movement angle in Windows 10?
I use my mouse at a 45 degree angle. When I move up on the mousepad, I want it to go up on screen, not at 45 degree angle. I remember in older versions of Windows there was a setting for this, but I ...
- 579
-1
votes
1
answer
8k
views
Excel scatter plot x axis displays only sequential numbers but not real data selected for x axis
I have an excel scatter plot with 5 different data series on single chart. First 4 series are working well. When I want to add a new series with similar x-axis data (0.0, 0.4, 0.9 .. ) the plot is ...
- 49
0
votes
1
answer
191
views
Excel Chart set axis units as 1, 25, 50,
I've not been able to find to a solution for this.
I plot some data as an X Y (Scatter) chart and want the horizontal axis to begin at 1 and then show the units which are multiples of 25, i.e the ...
4
votes
1
answer
9k
views
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' ...
- 43
2
votes
1
answer
6k
views
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 ...
- 121
0
votes
1
answer
562
views
Create Excel chart with two y-axes: constant data on axis 1, dropdown list data on axis 2?
Comfortable with adding a second axis to, and just learned how to use a drop-down list with, an Excel chart. Can't find anything about doing both at the same time. My example:
Calendar dates (or ...
- 1
0
votes
1
answer
559
views
Multiple labels on X-axis with only 1 point
I have a column graph in Excel with 19 columns, of which the 4th, 8th, 12th, and 16th are intentionally left blank.
As you can see in the legend there are esentially groups of 3 bars per subject. I ...
- 133
0
votes
1
answer
466
views
Matlab - how to put the same number of decimal places in the axes
How can I put all the axis numbers with the same number of decimal places on the chart? I want all y-axis numbers to have the same number of decimal places. Thanks.
- 103
1
vote
1
answer
3k
views
Touchscreen X and Y axis switched
i have a chinise DELONG DL070IA touchscreen that i bought from ebay a long time ago. I connected it to a windows 10 pc via USB. Everything worked except when i move my finger up and down the cursor ...
- 11
1
vote
2
answers
2k
views
Switching axis in Excel
I'm trying to switch the axes on this graph, so that SMI is on the x axis and number is on the y. That's what a lecturer told me to do anyway. If that's right, how do I do it? If not, why should I ...
3
votes
1
answer
13k
views
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 ...
- 31
1
vote
1
answer
13k
views
Single data series with both primary and secondary axis (in two different units)?
Is it possible to plot (line graph) a single data series and display both a primary axis and secondary axis, showing two different units? Currently I have the different y-axis units as a separate ...
- 11
0
votes
0
answers
1k
views
x axis formatting with dynamic excel chart
I'm having a problem with a dynamic x,y chart.
I set up named ranges using this method:
My x axis label is "time" =OFFSET(graf!$D$2,0,0,COUNTA(graf!$D$2:$D$1000)-1)
I do the same for my data (y ...
3
votes
3
answers
75k
views
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 ...
- 145
1
vote
0
answers
192
views
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 ...
- 11
1
vote
1
answer
462
views
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 ...
- 13
2
votes
2
answers
3k
views
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 ...
- 33
0
votes
2
answers
3k
views
Forcing axis units in Excel 2013 plots, being written after minimum bound of axis
I have a plot, drawn in Excel 2013. The data begins from almost 0.9 to almost 5.1. I want the x axis to be written from 1 to 5 and to show the data from 0.9 to 5.1.
Upon my best effort, I could set ...
- 547
0
votes
1
answer
3k
views
Placement of Secondary Horizontal Axis
On the primary horizontal axis I can go to Format Axis > Line Color and Style. There I can choose the color and style of the line that represents 0 on the primary vertical axis.
However, with the ...
- 983
0
votes
1
answer
23k
views
Chart labeling: durations in minutes and seconds
I am attempting to chart the durations of phone interactions. They are currently entered as time of day values (I did not build the workbook), even though they are actually duration values, and Excel ...
0
votes
1
answer
3k
views
Plot two time series with same start and end time: data does not align with axis
I'm trying to plot graphs for pressure and temperature recorded on different devices.
The number of data recorded for each device is different (Eg. pressure has 1 reading per second while temperature ...
- 13
0
votes
1
answer
203
views
Excel chart axis with personal label instead of number
I'm a simpleton with excel but writing a research dissertation. Much charting involved...
My y axis has values 0-6 but each number represents a patient response (for example never, very rarely, ...
- 1
1
vote
0
answers
286
views
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 ...
- 11
1
vote
1
answer
8k
views
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....
- 123
4
votes
2
answers
13k
views
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 ...
- 977
1
vote
2
answers
2k
views
Get Excel to use column of numbers as labels (equally-spaced on x-axis) instead of as x values (x-axis co-ordinates)
It could be an easy question but I can't find a proper way to accomplish my task.
I have a simple graph and all I want is to show the X values I wrote in the first column at the bottom of the graph (...
- 111
1
vote
2
answers
3k
views
Changing the axis labeling in a Excel 2010 scatter plot
I am trying to represent a list of data points in such a way that the graph starts at X coordinate '1' but that labeling starts at coordinate '100' and I have been unable to find out how to do it as ...
- 123
0
votes
2
answers
1k
views
Excel 2010 > Chart Axis Formatting
I have a chart that has a primary and secondary headings. But, in the chart I can't find a way to just bold the primary heading. The table that the chart is created from has the primary headings ...
- 1
2
votes
0
answers
237
views
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....
- 21
1
vote
1
answer
4k
views
Time units and automatic formatting of the y-axis in Excel
I have a chart with time values on the vertical (Y) axis. As the values can change a lot the formatting of the axis minor and major units is automatic.
The problem is that Excel chooses values which ...
- 7,587
3
votes
1
answer
59k
views
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 | ...
- 135