After Hours

Ask something
Question Locked

X axis in Excel graph

0 helpful
3 replies

by nhiep_nguyen 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello Everyone,

I have a problem with Excel graphics that I am not sure is solvable, so I submit it to the Techrepublic community hoping that someone would be able to help me.
To simplify the problem let's say that in Excel spread sheet I have two columns, one (A) is in Date format, the other (B) is in currency format.
Values in the A column are entered not in a regular basis, with the corresponding values in the B column.
Now I would like to graph the evolution of the amounts in the B column versus Time, with A column as X values.
The problem is that the X axis is set so that the values are reported one after another regardless of the time that separates the consecutive values; so the curve does not reflect the real evolution of the money vs time.
How could I set the X axis so that the real length of time is reflected on the X axis?
Thank you for any input.

3 replies

by thumbsup2

Let's see if I understand you correctly. Are you saying the graph equally spaces the x axis values instead of proportionally spacing them? Here's a graphical representation. T = Time

It currently does this:

T1.....T2.....T3.....T4.....T5.....T6.....T7

And you want it to do this:

T1...T2......T3.....T4..T5.........T6....T7

With the value of column B sitting exactly above the unequal time spacing.

Is that correct?

by dave simonis

Okay, I'm a little confused...so maybe it's just because I'm not fully understanding your wording.

You have 2 colums, one has dates, the other is a cummulative or a single instance (?). From here, you want to see this data spread out over "days" as the unit on the x-axis, not just as points on the X-axis with no real correlation of time in between these points? You talk about a "curve" being plotted, but honestly you must mean just a line or area (probably more jagged) because I am assuming you are looking at a graph of the data entered and not a moving average or smoothed interpolation of data correct? What version of Excel are you using? How many dates do you want to see...every date (2/1, 2/2, 2/3 etc)?

Also wondering, after you have created the graph, have you dbl clicked on the labels along the x-axis and viewed the settings?

DDS

This discussion is closed to new replies.