Teach Yourself Excel Lesson Format Data - Format Data

Some background:
I have 40 individual data points that I am plotting on a scatter plot in excel. As I add them, I am having to go, each time, and update the format of the data labels.

What i need is only a label and no data point or line to appear on the scatter plot. I want it to have a boarder and be in about 14 pt font. Right now i am putting all of the data points above the center to make room for the possibility that i have more then one data label on a single point. (Since i have only values 1-5 and 40 data points the possibility is high that this will happen). I also want to be able to leave some spaces blank (or at 0,0) so that i can add to the chart as needed.

The ultimate outcome would be that the chart automatically aligns the data labels so they are not over each other but this is not my main concern.

Is this possible in excel. I don't really see anything that gives an option for saving or repeating format.

Thanks for the help!!

I have a spreadsheet of around 600 rows.

In column R is a list of data, which is seperated by a comma.

Example:

Name, Address, Address2, Post Code

I want to create a macro that runs through each cell in column R and formats the data so it appers like this in each cell:

Name,
Address,
Address2,
Post Code

In otherwards, doing exactly what you would do if you were manually pressing Alt and Enter after every comma?

Is this possible?

Thanks

Hi! I have a whole year's worth of data in column format and need to modify it to a row format. Here's what I have now:

Date Hour Data
1/1/2011 1 3
1/1/2011 2 3
1/1/2011 3 3
1/1/2011 4 3
1/1/2011 5 3
1/1/2011 6 3
1/1/2011 7 3.5
1/1/2011 8 2.5
1/1/2011 9 5
1/1/2011 10 12.5
1/1/2011 11 12.5
1/1/2011 12 10
etc

I need to convert to this format:

1/1/2011 3 3 3 3 3 3 3.5 2.5 5 12.5 12.5 10
1/2/2011
etc

Is there a formula that can be used for the conversion process?

Thanks!

I want to feed Excel data about population and trends into a map format
instead of a bar graph or pie chart. Is there a plug-in or some such thing
that I can use that works with Excel? Ultimately, I want to have each state
depicted by a color code for a range of population or an amount of certain
data.
I am using Excel 2002 in a Windows XP environment.

Hi all-

I wanted to reformat my data from this:

Item Qty 1-Jan 8-Jan 15-Jan 22-Jan
ABC1 1000 77 77 77 77
ABC2 500 38 38 38 38
ABC3 10000 769 769 769 769

to this:

Item Date Qty
ABC1 1-Jan 77
ABC1 8-Jan 77
ABC1 15-Jan 77
ABC1 22-Jan 77
ABC2 1-Jan 38
ABC2 8-Jan 38
ABC2 15-Jan 38
ABC2 22-Jan 38
ABC3 1-Jan 769
ABC3 8-Jan 769
ABC3 15-Jan 769
ABC3 22-Jan 769

I'll appreciate any help on this.

thanks.

Hi all i am trying to create a text file from the data on the CLI page of this work sheet
i have automated most of it but that's it my knowledge is now not good enough to com-pleat it hope someone can help

i have included a text file of the output i would like to achieve and please note the extra two line at the bottom i need them in too thanks for any help

and if any one else wishes to use this doc to manage there brocades then you are welcome to use it

I tried to find search for this in the forums, but I could only find bits and pieces here and there and I was unable to put enough code together to make this work. So please accept my apologies if this is a duplicate of another post somehwere out here, but I truly appreciate the help!

Okay, here we go...I have 6 columns of data (in most cases column 6 doesn't have data but it can). Row 1 is a header row. It can have 1 row of data starting in row 2 or it could have 1000 rows of data staring in row 2. I'm looking for, I believe, VB code or a macro button that will export the data in CSV format. The export can NOT include the header row (row 1). The export MUST have 6 columns of data - this is really, really important (meaning it MUST have 6 commas even if only the first 5 columns have data in them (whereas the File->SaveAs CSV feature only puts 4 commas on 5 columns of data and only 5 commas on 6 columns of data).

Sample Data (worksheet 1, cells A1:F4):
Serial Model Date Value Code Credits 12345678 ABC123 10/30/2008 102588 BW 12345678 ABC123 10/30/2008 50806 CO 22334455 XYZ405 10/29/2008 28123 BW 10

The output (CSV) needs to look like this:
12345678,ABC123,10/30/2008,102588,BW,,
12345678,ABC123,10/30/2008,50806,CO,,
22334455,XYZ405,10/29/2008,28123,BW,10,

My other needs are as follows:

1. I'd like to just push a button to execute this. I know how to assign a button to a macro, but I don't know how to assign a button to VB code. I do have a local resource that I could probably get help with this on if this isn't part of the code itself.

2. When the data is output, I'd like the file name to be consistent. Possibly pulling a default name from Cell A1 on say worksheet 2. But then automatically adding the date and time onto the file name. So something like this..."myfilename_20081030_1405.txt". I'm not sure of proper time formatting, but here 1405 is 2:50pm (in military time). But 205pm would be acceptable as well.

3. I don't care if the file is saved as .csv, .txt, or without a file extension altogether, but I'd PREFER no file extension (so "myfilename_20081030_1405" would be ideal, but not required).

4. On Worksheet 2, say in cell A2, I'd like to set the file path of where the file will be saved to (like C:\ or something like that). But rather than automatically saving the file, I'd like the SAVE-AS window to open up, with the file path default from worksheet 2 cell A2, and with the file name pre-populated so the user can either a) just hit save or b) they can give the file a different name and/or save the file to a different location. If this isn't possible, I'd be okay just saving the file to the default file path location.

5. On the "data" on worksheet 1 is output. So starting with Row 2 on worksheet 1, if there's only 1 row of data, then only 1 row of CSV data is output. If there are 95 rows of data starting on row 2 of worksheet 1, then 95 rows of data are output. Okay, I think you get the idea.

I can't wait to see if this is possible or not. Many thanks in advance for the assistance.

I have a service where a printed registration code is used to register online. I have created all of the the random reg. codes where they correspond to a product number. These codes and product numbers are then uploaded to a website database.

How can I take those codes and import them into another spreadsheet so that they are in a automatic printable format somewhat like this:

Registration Code
Btu7m4R
Very Important!!!

I am dealing with mass volumes and need to make it as automatic as possible.