ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

19 Q & A posts tagged with CHAR

Wed
Dec 7
2011

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.

Wednesday 12/7/2011 10:50:00 AM
Sat
May 8
2010

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

Saturday 5/8/2010 7:10:13 PM
Tue
May 4
2010

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

Tuesday 5/4/2010 4:02:44 AM
Mon
May 3
2010

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

Monday 5/3/2010 1:00:36 PM
Sun
Apr 11
2010

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

Sunday 4/11/2010 4:40:21 PM
Sat
Apr 10
2010

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

Saturday 4/10/2010 2:36:50 PM
Sat
Apr 10
2010

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

Saturday 4/10/2010 2:22:57 PM
Sat
Apr 10
2010

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

Saturday 4/10/2010 3:58:16 AM
Sun
Apr 26
2009

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

Sunday 4/26/2009 3:23:34 AM
Mon
Apr 20
2009

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

Monday 4/20/2009 2:20:15 PM
Mon
Apr 13
2009

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

Monday 4/13/2009 3:44:05 AM
Sun
Apr 12
2009

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

Sunday 4/12/2009 9:00:33 PM
Mon
Apr 6
2009

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

Monday 4/6/2009 4:14:56 PM
Mon
Apr 6
2009

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

Monday 4/6/2009 2:14:09 PM
Mon
Apr 6
2009

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

Monday 4/6/2009 2:45:48 AM
Mon
Apr 6
2009

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

Monday 4/6/2009 1:56:36 AM
Wed
Apr 1
2009

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

Wednesday 4/1/2009 10:39:02 AM
Tue
Dec 12
2006

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

Tuesday 12/12/2006 5:47:50 AM
Tue
Dec 5
2006

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

Tuesday 12/5/2006 2:10:13 PM

Tags

History