Mr Excel & excelisfun Trick #4: Comparative Charts

[moonboy0001]

Hello love your video! One question. My formulae =A1&char(10)&B1 does not return to the same result as hit Alt+Enter. Could you help me please?

[ExcelIsFun]

You have to be sure to also have "Wrap Text" applied to the cell.

[akonini1]

You two are all clever. Thanks for sharing your ideas.

I am hoping this will not lead to a competition but purely for helping others.

[ExcelIsFun]

Even it where a competition, which it is not, viewers will always benefit! With over 2000 videos about how to use Excel - Woo Hoo!!!

[rajus0]

Thanks for making this video i am going to try it later. I need to compare age and company level for a university project. So i hope that this will help me i will comment back later to tell you how it goes

[ExcelIsFun]

EXCELlent!!!

[rajus0]

Hey i am having a bit of problem. It all worked i am trying to sort out the Data labels. i have a column chart and then a line graph over the front i want the line graph data labels to show the different options. I have got it saying this in the select data screen but when it comes to the data labels it wont work.

[ExcelIsFun]

I don't know how to do that. You can post your question to the Mr Excel Message Board:

mrexcel[dot]com/forum

[brancheb1]

I've listened to many many tutorials on vlookup nad chart/index. BOth of you two make excel fun! I don't know what function to use to compare data between 2 spreadsheets. I need to find where the two sheets differ?

[ExcelIsFun]

Search for this playlist with many videos for comparing two lists:

Excel Compare / Merge Two Lists

[SFDSea]

very nice

[ExcelIsFun]

I am glad that you like it! Since you live in the Seattle area, I can't wait to see you live in the Highline Spring Busn 214 class!

[poornamalwana]

excelisfun video is tha best tutorials..........

[ExcelIsFun]

I am glad that you like them!!

[gandukabacha]

thanks a lot it worked

[ExcelIsFun]

Dear gandukabacha,

EXCELlent!!!!

--excelisfun

[gandukabacha]

the char(10) is not working for me on excel 2003. its giving me calues togeather like "goodbad" but not giving me value like good on top and bad below...why is that

[ExcelIsFun]

Dear gandukabacha,

Try word wrap on the cell. But remember, the word wrap is for the whole cell and the CHAR(10) is to tell the formula to drop the remaining text down at that point. If you did not have the CHAR(10) then the point at which Excel dropped text down to the next line would vary.

I hope that helps.

--excelisfun

[MCID4500]

Great Video. I hope to see more video for VBA Excel.

[ExcelIsFun]

Dear MCID4500,

To ask questions about VBA Excel, post a question to the Mr Excel Message Board. I have made a video that shows how to post to this amazing site:

How To Post Questions At The Mr Excel Message Board

--excelisfun

[ExcelIsFun]

Dear MCID4500,

Mr Excel has a video series coming out soon on VBA. Check out his web site.

--excelisfun

[SheLuvsHerIpod]

I love it!

[ExcelIsFun]

Dear SheLuvsHerIpod,

Thanks!

I love doing all these videos!

And, since Excel is so much fun, You Got To Love It!

--excelisfun

[moazzamca1]

Thats really awesome you gurus, hats off to both of you.

[moazzamca1]

Thats really awesome you gurus, hats off to both of you.

[ExcelIsFun]

You are welcome!

[SheLuvsHerIpod]

I like to think of these as duets rather than duels...I love 'em.

[ExcelIsFun]

Dear SheLuvsHerIpod,

I totally agree!!!! I like to call them:

duo-dual-duels.

But now I will have to call them:

duo-dual-duels-duets!!!

--excelisfun