## 19 Q & A posts tagged with CHAR

### How can I combine two cells into one with Enter between them?

I have cell A1 with name, B1 with Address, I want C1 to have NAme from A1 in one line, then the Address from B1 in line below, I don't want to go all over my 13000 cells to do that manually

### Answer

That is very good question, here is what you need to do:

In C1, paste this:

= A1&CHAR( 10)&B1

You might need to select "Wrap Text" to show that

The CHAR(10) is what is called the Enter inside the cell.

### How to create a fixed x-axis in Excel 2007 charts?

I need to make an Excel 2007 line chart with a fixed x-axis that starts at 0 with tic marks every 10 values up to 100. My data values fall within this range, but I don't want the data points to determine the x-axis. Can someone tell me how to do this?

### Answer

Right click on that X-axis, and click "Format Axis"

Then, make sure you check the options that said "Fixed", instead of "Auto"

Doing that will make it fixed to the specified values, even when the line goes out

VBAXLMan

### How would I create the type of graph shown in the link below?

I have data in excel for the daily minimum and maximum temperatures and daily rainfall for a full year.

Also, what is the name of this style of graph?

### Answer

Use the regular column chart

It is called Histogram, but Excel will not recognize that name, use Column chart

Assuming you have the data listed by date.

VBAXLMan

### Need help putting quotes around my text in excel spreadsheet?

Hi,

I have an excel spreadsheet with different words in all the cells. I need to put quotes around each word. I have tried using a macro but I am new to it and so far have not been able to get it to not just paste the exact same word I used to record the macro. Every cell is a different word. I need the macro to ignore the word in the cell and just put quotes around each individual word. Can anyone help with this??? I appreciate it!

### Answer

The char code for the quotes is 34

Meaning, if you use Chr(34) in VBA code

or

=CHAR(34) in Excel formulas, you will get the quote

Maybe something like this, in formula bar

=CHAR(34)&C1&CHAR(34)

or

Range("A1").value= Chr(34) & Range("A1").value & Chr(34)

Hope this will help

VBAXLMan

### How do I make a half life graph on excel?

Excel keeps making it into a weird kind of graph, and I want a line graph with the years as the X axis and % left as the Y axis

### Answer

Once you have the values in two columns

Insert chart, make sure you select the XY-Scatter from the chart type

VBAXLMan

### How do I make a comparison chart using formulas in Excel?

I have an assignment to do where I need to research three different computers and make a comparison chart to find out which is the best computer for the money. The only problem I'm having is that I was never taught how to do this using formulas and/or functions. What formulas would I use to compare different things and find which is the best?

### Answer

Your question is so general

But let me try

You need first to build the table

Based on the data you have, you need to study formulas like

=A1/A2

or

=

besides IF, SUM, AVERAGE

most of these formulas are in Insert > Functions (if you have Excel2003 or earlier)

or in Formulas tab > Insert Functions (If Excel2007)

Let me know if that worked or not

VBAXLMan

### How do you add a critical value as a dotted line to a column chart in excel?

### Answer

Use "Add Data" to add new series

First you need to create a new column in the spreadsheet itself having that critical value (one value for all column cells)

Then add it to the graph

You can add it either from "New Series" or "Add Data" depend on your Excel version

Or, add it as regular bar, then change its type to XY-Scatter

Let me know if that make sense

VBAXLMan

### How do i create a dynamic chart in excel 2007 that creates a chart from ONE CELL only that is updating....?

how do i create a dynamic chart in excel 2007 that creates a chart from ONE CELL only that is updating its data from an external source every sec....i want to plot the values as they change into an excel chart live from this one cell...thanks, christian

### Answer

When you create a chart, make sure you select THAT CELL when it asks for the value

Doing this will make that chart updated every time the cell is updated

That is what I got from your question

VBAXLMan

### Excel: is there a way to emulate the lower function without using lower()?

Excel: is there a way to emulate the lower function without using lower()??

note: it has to work for cells with 2 or more words

### Answer

I think there is, but it is going to be too long and time consuming

If your cell is in A1, paste this in B1

=IF(CODE(MID( $A$1,COLUMN()-1,1))=32," ",CHAR( CODE(MID( $A$1,COLUMN( )-1,1))-32))

Then drag it to right to cover all letters of that text

After that, you can easily use CONCATENATE or the & symbol to assemble them into one cell text, like this

=B1&C1&D1&D1

or

=CONCATENATE(B1,C1,D1, E1)

until you reach the end

good luck

VBAXLMan

### How the heck do I use MS Excel?

I need to make charts using MS Excel but am lost. How in the heck do I learn how to use it?

### Answer

These videos will help a lot

http://www.youtube.com/results?search_ty…

VBAXLMan

### MS Excel . I want to search the value of one cell among other cells to check the validity of that cell among o?

Dear Sir/Madam,

To make my question more clear I want to search the value of one cell among other cells to check the validity of that cell among other cells.for instance,

a1:Jack

b1:paula

b2:jack

b3:matue

b4:sara

in case of making chart c1:true or false

in this example=T

a1:Jack

b1:paula

b2:sam

b3:matue

b4;sara

in case of makin chart c1:true or false

in this example=f

### Answer

You can use COUNTIF, like this

=COUNTIF( A1, B:B)

To count the number of times that the cell A1 showed in the range B:B

Or may be like this

=IF( COUNTIF( A1,B:B))

To get True or False

That is what I could understand from your foggy question

VBAXLMan

### HELP?!?!??! Microsoft excel?

I made a bar graph on Microsoft excel but how do i label the bars (along the X axis) ??

plz help, rlly confusin

thnkx in advance =]

### Answer

In Excel2003, do these steps:

1- Select the graph

2- Go to Chart > Chart Options

3- Then go to Chart Titles and change the boxes for x-axis and y-axis labels

In Excle2007, do these

1- Select the graph

2- Two new tabs will be shown after the last one, go to

Layout > Axis title

Then do the Horizontal or Vertical one, based on your needs

VBAXLMan

### How to print a chart in Excel 2007?

Help! I have an assignment due tomorrow where I had to make bar graphs in Excel 2007. The graphs are showing up perfectly in print preview, but the actual bars won't print. The X and Y axis and chart title prints only. I have a HP Officejet 6210. I have no idea what to do. Thanks!

### Answer

You need to do these steps as they are the most popular reasons for problems like this

1- Clear history and cookies

2- Delete temporary internet files

Both 1 and 2 are in Internet options from Control panel

3- Delete "Temp" folder content (and not the folder), it is in your C: > documents and settings > YOURUSERNAME > Local settings > Temp, this will solve a lot of problems

4- Restart computer and try again

Do Step 3 if you are using WinXP, if you have VISTA, then step 3 would be

3- Delete "Temp" folder content (and not the folder), it is in your C: > Users > YOURUSERNAME > AppData > Temp, this will solve a lot of problems

VBAXLMan

### Excel Chart Function?

The problem is this: To generate chart on a chart sheet u should:

1. Generate it on excel sheet 2) Select the function Move Chart 3) select Chart.

In my case, when I select Chart (3) I get a blank sheet and the chart does not appear on the selected chart

Thank u

### Answer

That sounds weird

Try this...

You need to do these steps as they are the most popular reasons for problems like yours

1- Clear history and cookies

2- Delete temporary internet files

Both 1 and 2 are in Internet options from Control panel

3- Delete "Temp" folder content (and not the folder), it is in your C: > documents and settings > YOURUSERNAME > Local settings > Temp, this will solve a lot of problems

4- Restart computer and try again

Do Step 3 if you are using WinXP, if you have VISTA, then step 3 would be

3- Delete "Temp" folder content (and not the folder), it is in your C: > Users > YOURUSERNAME > AppData > Temp, this will solve a lot of problems

VBAXLMan

### Moving a chart to a new page?

I am using excel 2007. After I making the chart on the excel sheet I cannot move the chart into a new chart sheet

### Answer

Try cleaning up your temp...

You need to do these steps as they are the most popular reasons for problems like yours

1- Clear history and cookies

2- Delete temporary internet files

Both 1 and 2 are in Internet options from Control panel

3- Delete "Temp" folder content (and not the folder), it is in your C: > documents and settings > YOURUSERNAME > Local settings > Temp, this will solve a lot of problems

4- Restart computer and try again

Do Step 3 if you are using WinXP, if you have VISTA, then step 3 would be

3- Delete "Temp" folder content (and not the folder), it is in your C: > Users > YOURUSERNAME > AppData > Temp, this will solve a lot of problems

VBAXLMan

### Excel 2007 - Using words in the y-axis?

Hi, I'm trying to make a line chart and coordinating times with letter values where the time is on the X-axis.

i.e.

1200 is ACA

1300 is ACC

1400 is BAD

I need to put the letters/initials into the Y-Axis so instead of charting numbers to numbers, it'll do letters and on the Y-Axis I'll have AAA, AAB, AAC et cetera.

How do I do that? Thank you!

### Answer

The Y-axis is where the values are drawn, meaning you can not put letters since letters can not be drawn as line

The Y-Axis has the values that representing the line itself

Does that make sense?

VBAXLMan

### How do I draw a normal curve graph on Excel?

For my first set of data, I have a mean of 5.409090909 and a standard deviation of 1.370437585. For the second set, the mean is 4.590909091 and the standard deviation is 1.969289002. How can I draw a normal distribution curve? I have 22 values for each set. Any help would be appreciated.

Regards

### Answer

If I understood your question, do this:

Add new series (one for each mean and STDEV) with the same value for all points

And graph it

If this is not what you wanted, let me know

VBAXLMan

### I am not able to tick the 'chart menu bar' in ('tools'-'customise')Excel sheet.How it is possible?

This is to bring back the 'file' option in menu in Excel Sheet.Presently it is not displayed.Display starts from 'EDIT'

### Answer

I answered you,

Check the answer for this question in this link

http://answers.yahoo.com/question/index?…

Enjot mt profile, I am the VBAXLMan

### Hey! is there any Excel expert who can solve this.....? are u here Mr VBAXLMAN..?.?

i would like to create a line chart in ms excel....where "runs" will be ploted in y axis, or vertical axis and "overs" in horizontal axis....

runs will ploted in 50 runs interval and overs will be in 10 overs interval....u might have seen this in cricket...

wait .....it's not so easy one....i've a few conditions

1) the resultant line will be displayed in a single line,,,,i repeat ..in a single line....as u would have noticed in cricket score analysis.

2)it will start from the (0,0) point...that means 0 run at 0 over...

and will travel with the increasing runs and respected overs...(as it is made in graph papers.)

3)i'm using msexcel 2002....so pls solve it in 2002 or older....

i think i've expressed it enough....

if u 've done it then try this for two teams for there score analysis .....obviously there will two seperate line for two teams , say India & Pakistan or Australia & NewZealand...

every good answer will get a thumbs up and the best answer ......u know better

### Answer

I got your e-mail.

The solution is all in the table that you will create for it

Wherever hard you think the chart is, the solution is in the table

Excel charts are created from tables, means that you can not (Never) create a chart without its data.

So we are (You and me) have to see how to build the table that will represent the chart

I can't e-mail you through Yahoo, you have not confirmed your e-mail there...

send me your e-mail address, I can not e-mail you

Enjoy my profile, I am the VBAXLMan