MS Excel question (labeling charts)

I'm making a bar chart with Excel.

The "Y axis" (horizontal line) is currently marked as 1, 2, 3, etc through 11.

I need to change the value to "Feb 1 - Feb 15, 2004", "Feb 16 - Feb 29, 2004", etc..

How do I do that?

Chart is just a graphical representation of what's on your spreadsheet. If it came up blank for your axis it's because it's not defined in the s/s.

Okay, so how do I designate a field in text on the s/s?

In my chart, the total of each two week segment is in A20, B20, C20, etc... I typed "=sum(A4:a19)" in the value box.

How can I identify each value as a specific date/text?

n/t

I'm not sure if this answers your question.

If you want to type in Feb 1-15, but don't want the spreadsheet converting it to their idea of a date, type "Feb 1-15. I don't think you need to close the quotation.

Sometimes I type Jan in a column. The spreadsheet automatically converts it to January. If I want it to say Jan, I type "Jan.

Try this>>>

Open the Chart menu and select Attach Text. That will call up the Attach Text dialog box. To attach an x-axis label, you need to click on the Category (X) Axis option and then select OK.

That'll put a fake x-axis label of "X" (or whatever you choose) below your chart.

From the edit menu, select the bar and put what you want in and next select the button to accept the new data. That will alter the label.

Repeat for the y axis using the Attach Text dialog box.

These are the chart menu options:

Chart Type

Source Data

Chart Options

Location

Add Data

Add Trendline

I'm using Excel 97 and this is what the menu says.

<snip>

Add a title to a chart or axis

1In PowerPoint, double-click the chart to which you want to add a title.
2On the Chart menu, click Chart Options, and then click the Titles tab.
3To add a chart title, click in the Chart title box, and then type the text you want.

To add one or more axis titles, click in the appropriate box for each title, and then type the text you want.

4To return to PowerPoint, click outside the chart.

Tip To insert a line break in a chart title or axis title, click the text in the chart, click where you want to insert the line break, and then press ENTER.

<snip>

on the Y axis. Try to go back to the spreadsheet and format the column or row as dates as follows:

1) Highlight the cells you want to change
2) Choose Format/Cells
3) Go to the "Number" tab
4) Make it a Date, choose the date type, and click OK.
5) Type in the dates you wish to see aligned with the data.

After that, check and see if your chart is now reading dates in the Y axis.

So here goes--the horizontal line is the x-axis, the vertical is the y.

In your spreadsheet do a column of cells put Feb x--xx, in one Feb y-yy in the next etc until you have all that you need. In the next column over put your dependent data (you know, whatever that'd be, sales figures, snowfall, whatever you're looking at) Highlight the second column go to chart wizard, then do Bar graph etc, hit "next" and when you see the first graph go to the "series" tab make sure your curosr is now in the X-series box; now go back to you spreadsheet and highlight the column of cells with you date information and voila, that's now your x-axis.

I hope that helps

...gave up...printed a sheet with the dates on it and took the scissors/scotch tape approach.
Looks great!

dammit why won't why .bmp load?

http://img.photobucket.com/albums/v212/catzies/spreadsheet.bmp