Free Microsoft Excel 2013 Quick Reference

Change Date to Text on X Axis

I'm building xlXYScatterSmooth chart with the Date on X axis. I'd like to change it to Text but don't know how. Here is my code

Thank you very much. 


Post your answer or comment

comments powered by Disqus
Trying to plot data from two colums:
X-Axis: Column 1 is Date/Time (mm/dd/yy hh:mm, e.g. 11/21/06 13:10),
Y-Axis: Column 2 is pH (number to 2 decimal places, e.g. 8.24).

QUESTIONS:
1 - I do not know what DATA RANGE is and not sure what I should be
highlighting/selecting for data range.

2 - Can not get Date/Time data in column 1 to show properly on X axis of
chart...will show date but not time so all points are lumped into one area on
top of each other...number format for chart and data have been changed to be
the same.

Hello,

New at this, so please bear with me a bit.

Have a very simple line graph with one column formatted as dates, and the next two columns showing blood pressure.

It graphs pretty nicely.

But, I want to change the date scale on the x axis Chart to show the months for the following year. This is what I want to show, even though at present I only have abosut a month's worth of data. The x axis shows this months dates, but no further. I wish to expand the x axis to show months for a year out (even though only one month, now, has data.

I cannot find any Format Axis type of command that will let me select the starting date for the graph, and the end date (12 months hence), even though I only have about a months' worth of data presently.

I've done this before, and never had any problem bringing up a screen to select the start and end date, after I simply clicked on the x axis. At least, this is the way I remember it.

The Format Axis screen that does show up when I click on an axis does not seem to have this option.

I do have, in the data page column, and for the chart, this x axis formatted for "Dates". Or, at least I think I do.

Any help on this would be most appreciated.

Thanks,
Bob

I am trying to combine 2 columns of data to create on x axis (I have to
create an Asthma peak flow chart and have 4 different times per day with
figures - before & after), so each day has 4 lines. I need to show data and
graph (if possible) on one sheet to take to the hospital. At the moment the
column is too long to be readable in landscape (with graph) and I can't find
a way to change orientation of graph to make it readable in portrait. Is
anything possible (my dates are like 01 8, 01 12, 01 16, 01 20 etc. for
every day in the month).

Dear Forum,
I am making a graph using a table of data. The graph’s x-axis contains the data’s dates. The data for the bars is copied from another tab. I would like to copy the dates from the same tab but when I attempt to do this,

If the date is entered manually, the date range displays as I intend it to, and the graph resizes depending on the amount of dates entered, however if the dates are copied from another tab (which is what I want to be able to do), the x-axis of the graph displays incorrectly.

Can anybody help me solve this problem?
My file is too big for the forum so I have attached it here: http://uploading.com/files/89c7edc2/...2B110308k.zip/

Thank you,
Casper

I have dates on x axis, from Oct 10 1999 through June 19 2000. I would like
to put numbers, starting with 1, above each date. Is it possible to do this
as another x axis or is the only option to physically put each number above
each date (such as a text box), such as, the number 1 above Oct 10 1999, the
number 2 above Oct 11 1999, etc. Thanks for any reply.

Hi All,

I have a data series where the X-values (dates) are neither continuous nor in equal gap or interval. How can I show only the dates on X-axis for which I have a Y-value?

Attached file will clear the problem. In the file, the graph shows all the X-values (dates) at equal interval. I want only the dates to be seen for which there is a price point or Y-value, like 1-Jul then 5th Jul, 18th July and so on.

Can it be done in Excel 2007?

Awaiting your replies.

--Warm Regards,

I made a graph in Excel which contains some numbers vs. texts. I managed to changed the color of numbers on y-axis but how can I make the texts on the x-axis colorful ? Seek detail answer, plz.

I have two layers of labels on the X axis.Top labels are days of the
month 1-30 or 31. Under that is the month - May, June etc. I cannot
seem to change the interval between labels, to show for example days
of the month as 1, 3, 5 ... rather than 1, 2, 3 ... I can change the
interval in the Format Axis dialogue box but this does not flow
through to the chart. I'm thinking it is something to do with having
two layers of labels. Anyone have any thoughts?

I'm using windows XP excel 2000 professional version and having problems
printing a scatter chart for the data. The x axis should show the date,
which it does on another computer exactly like mine. I have elininated the
printer as the problem .

I have three columns (Date, Time, and Temperature) that I am trying to
graph as a scatter chart. I would like Date and Time together on the
x-axis and I would like Temperature on the y-axis. I can't get the
date and time combined on the x-axis. There are multiple measurements
on the same day and the measurements are not spaced evenly. I would
like the scale to be with a consistent unit (i.e. certain number of
hours between points). Any suggestions?

Thanks,
Cindy

--
cdoughty
------------------------------------------------------------------------
cdoughty's Profile: http://www.excelforum.com/member.php...o&userid=25988
View this thread: http://www.excelforum.com/showthread...hreadid=398141

The problem is that if you have dates as the X-axis series for a chart, the
only options for Base Units are Days, Months or Years. If you have
quarterly data, excel adds extra space between the data points.

A simple example illustrates the problem:

Create a column chart from the following data

Quarter Value
31-Mar-04 3
30-Jun-04 6
30-Sep-04 9
31-Dec-04 12

Note that the dates to appear on the X axis are the end of each quarter
(every 3rd month)

Create a simple Column chart from the data.
Right-click on the data series and choose Format Data Series, Options
Set the Overlap and Gap-width to 0.

You will see that there is still a large gap between each Column. Setting
both to 0 for a column chart normally expands the width of the columns so
that they fill the entire width of the chart.

In this case, each column only fills 1/3 of the width available.

To see the cause, right-click the X-axis and choose Scale. Note that the
only Base units are Day, Month and Year.

The reason for the extra space between the columns is that Excel is leaving
space for the missing months even though there is no data for them.

Does anyone know a way around this?

The only way I have found is to convert the dates to text, so that Excel
does not recognise them as dates.

thanks

Peter

I have three columns (Date, Time, and Temperature) that I am trying to graph as a scatter chart. I would like Date and Time together on the x-axis and I would like Temperature on the y-axis. I can't get the date and time combined on the x-axis. There are multiple measurements on the same day and the measurements are not spaced evenly. I would like the scale to be with a consistent unit (i.e. certain number of hours between points). Any suggestions?

Thanks,
Cindy

i have a chart which i want to display either weekly results or period results.

there is a range a1:b52 which will either display every weeks result or period results on the basis of what is in a drop down box

the chart is linked to this range a1:b52

i want the chart to alter x axis to either 52 increments if weeks are selected or just 13 if periods are selected

as it is now, it looks ok when weeks are selected but when you select period it displays the first 13 out of 52 as periods and the rest blank so it's all squashed to the left rather than being spread out

any suggestions.

How to draw chart: log scale on X axis, natural scale on y axis? sample data
is given below. This chart is used for Civil Engineering?

X axis Y axis
Sieve size % passing
26 mm 100
22 mm 95
16 mm 81
12 mm 75
10 mm 66
4.8 mm 52
2.4 mm 42
1.2 mm 32
0.6 mm 18
0.3 mm 16
0.15 mm 9
0.09 mm 3

Hi,

I would like to plot a monthly time series. The first point is always 1st of every month, but the last day is the current day. For example, today is 19th, and so, it will plot every value up til 19th. If today is the 25th, then the x-axis will automatically adjust to 25 points.

The data for dates are in Column A (starting from A1 to A&" the current day") while Column B is the observed value for that corresponding day.

Thank you

My data are capture dates and associated water temperatures for immigrating steelhead. The immigrating steelhead life stage in the river I work with is July through March. Ive got the dates in a column starting with July 1 and ending March 31. When I plot these data the x-axis automatically is January through December. For these data I need the x-axis to read, from left to right, July through January.

Ive double clicked the x-axis to play with the scale. I can manipulate the numbers to get the x-axis scale to read July, August, September, October, November, December, January,...., March. However, when I do this my data are not diplayed in the plot. I just cant figure this one out.

Any suggestions? These data must be presented in an x,y scatterplot (for some reason I can accomplish this task with other chart types).

I am plotting two time series lines on a line graph (they show up as a single
line, solid for the actuals and dotted for the forecast):

Yr. TS-1(actuals ) TS-2 (forecast)
----- ---------------- ------------------
2001 value1
2002 value 2
2003 value 3 value 3
2004 value 4
2005 value 5

When I plot this, I get consecutive numbers (i.e. 1, 2, 3, 4, 5) instead of
years as labels on the x-axis. How do I fix this? THANKS!

Hi!

Is there any way to have the background in a chart have different
colors depending on x-axis values?

Like
x-axis value 1-10 => blue background
x-axis value 10-20 => red background

Thanks

--
RealRaven
------------------------------------------------------------------------
RealRaven's Profile: http://www.excelforum.com/member.php...o&userid=37058
View this thread: http://www.excelforum.com/showthread...hreadid=567788

Ive added secondary y axes before, so you can have a series relating to the
left hand axis and one on the right, but with a common x axis

but is there an easy way to have two x axis, one at the top and one at the
bottom. i don't actually need a 2nd series, but I want my charts to have one
unit across the bottom (dose) and another along the top (exposure index)
just for reference, so that visually I can look at the curve and read off
either dose (at the bottom of the chart), or exposure (at the top)

thanks in advance

I APOLOGIIZE IN ADVANCE IF THIS IS A DUPLICATE POST. I POSTED 3 HOURS
AGO AND IT STILL HAS NOT APPEARED IN THE EXCEL AREA, SO I ASSUME
SOMETHING WENT WRONG!

I am attempting to convert a date to text, and am having trouble with
the formatting. Specifically, I wish to convert a date in the form mm/
dd/yyyy to text in exactly the same format.

I am using excel 2000.

Using the command =Text(Text,text-format), I am having trouble with
the format piece.

"Help" tell me that the format code is based on he "format cells
numeric" definitions. My problem is that the code appears to be a
number, and nowhere can I find what number produces what defined text
format!

Can someone either give me the code I need, or point me in the right
direction to get an answer.

Thanks in advance

I am attempting to convert a date to text, and am having trouble with
the formatting. Specifically, I wish to convert a date in the form mm/
dd/yyyy to text in exactly the same format.

I am using excel 2000.

Using the command =Text(Text,text-format), I am having trouble with
the format piece.

"Help" tell me that the format code is based on he "format cells
numeric" definitions. My problem is that the code appears to be a
number, and nowhere can I find what number produces what defined text
format!

Can someone either give me the code I need, or point mwe ni the right
direction to get an answwer.

Thanks in advance

How can I get a 90 degrees text alignment on x-axis from two columns.
It's only column B taht rotate. Column A is still horisontel. The serie
in column C gives a graf.

How would I create a macro that would change dates to the word " present" when that date becomes todays date and then change it to red text? For exxmple: A future date has been added to a list of dates. I want the date to change to the word "present" when that date in "real time" is reached and then color it red that way I can search the list for the word "present" to find the projects that are due.

Hope that makes sense. Thank you for any help that you can provide.

I am plotting two time series lines on a line graph (they show up as a single
line, solid for the actuals and dotted for the forecast):

Yr. TS-1(actuals ) TS-2 (forecast)
----- ---------------- ------------------
2001 value1
2002 value 2
2003 value 3 value 3
2004 value 4
2005 value 5

When I plot this, I get consecutive numbers (i.e. 1, 2, 3, 4, 5) instead of
years as labels on the x-axis. How do I fix this? THANKS!


No luck finding an answer? You could always try Google.