**1**

vote

**0**answers

22 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 ...

**1**

vote

**1**answer

21 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 ...

**2**

votes

**1**answer

42 views

### How to create chart in excel with multiple ranges in Y axis [closed]

What I am looking for is shown in the picture.
Is this possible in Excel 2010?

**1**

vote

**1**answer

52 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 ...

**0**

votes

**0**answers

82 views

### Link primary and secondary x-axis in Excel 2010

I have an y-axis and two x-axes, which are depending on each other. But this depencence is not taken into account in Excel 2010 and I can primarily move the secondary axis up and down the range by ...

**0**

votes

**2**answers

162 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 ...

**0**

votes

**1**answer

86 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 ...

**0**

votes

**1**answer

1k 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

897 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 ...

**0**

votes

**1**answer

89 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**

vote

**0**answers

75 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 ...

**1**

vote

**1**answer

713 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 ...

**1**

vote

**2**answers

5k 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 ...

**1**

vote

**2**answers

757 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 ...

**1**

vote

**2**answers

2k 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 ...

**0**

votes

**2**answers

591 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 ...

**2**

votes

**0**answers

94 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 ...

**1**

vote

**1**answer

3k 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 ...

**3**

votes

**1**answer

28k 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 | ...

**1**

vote

**0**answers

571 views

### Excel chart axis values are doubling up along the axis

Excel chart axis values are doubling up along the axis - how do I stop this happening? It is in both the primary and secondary scales. eg the axis shows 18, 20, 20, 22, 22, 24, 24, 25

**0**

votes

**2**answers

696 views

### Date axis with a partial year

I have a line chart with data spanning from February 2002 to today. At the moment, the date axis looks like this:
Is there a way to have the first date be Feb-02 (no change), but the next one be ...

**5**

votes

**2**answers

38k views

### 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 ...

**1**

vote

**2**answers

4k views

### Excel: How to create a chart that automatically scales the axis

I have 2 columns with values, say A and B which values I want to use as X and Y axes values correspondingly.
The values are the following:
A: 412 684 944 2009 9601
B: 7813,4 10377,6 11138,8 16216 ...

**1**

vote

**1**answer

2k views

### Mouse movement vertical axis inversion? (Mac OS X)

I would like to either run an AppleScript or use a Terminal command to invert the y-axis for mouse movement in OSX— and no, not like http://d.pr/w9z7 (/joke). Any ideas? I thought about checking for ...

**3**

votes

**3**answers

42k views

### 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 ...