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.

- Excel 2003 - Charts - "Data Range" and Date/Time data on X-Axis
- Formatting Dates Start & End On X Axis ?
- Trying to combine 2 columns of data to create one x axis in graph
- Graph won't allow dates on x-axis to be copied from another tab ...?
- Numbers above dates on x axis
- How to show discrete dates on X-axis
- Coloring the text on x-axis of a plot in Excel
- Excel 2007 - change interval between labels on X axis
- The dates to label the x axis on the scatter chart won't print
- Date and Time on X-axis
- Problem with date base units for x axis
- Date and Time on X-axis
- Charting weekly or period to display on x axis
- How to draw chart: log scale on X axis, natural scale on y axis?
- Graph with changing number of points on X-axis
- Chart With Dates As Months As X-Axis Not In Right Order
- How do I get years to show on x-axis?
- Different background color depending on x-axis value
- How to make "secondary x axis labels"
- Numeric date to text..formatting question
- Converting a date to text..Format question
- Two columns on X-axis
- Change date to word "present" change to red
- How do I get years to show on x-axis?

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.

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

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

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

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.

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,

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?

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 .

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

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

Thanks,

Cindy

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.

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

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

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

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!

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

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

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

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

It's only column B taht rotate. Column A is still horisontel. The serie

in column C gives a graf.

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

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.