1
vote
1answer
71 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
2answers
2k 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
1answer
320 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
2answers
601 views

Changing the axis labelling 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 labelling starts at coordinate '100' and I have been unable to find out how to do it as ...
1
vote
1answer
2k 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
1answer
12k 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
0answers
269 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
1
vote
2answers
1k views

How to generate a round-numbers graph in Excel?

folks! Now, I have an Excel file with measurements I made of some color patches (I work at a Press company), with a device called spectrophotometer. Here it is: ...
0
votes
2answers
452 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 ...
1
vote
2answers
2k 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 ...
3
votes
1answer
25k 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 ...