Home » Video » ...

How to name excel chart Videos

How to Create Dynamic Chart Titles in Excel

A viewer wanted my help to create titles in his Excel charts that dynamically updated to show - e.g. a Customer Name in the Chart title - when he "filtered" the ...

User Comments

Danny Rocks commented on 24 Feb 2011

@esanabria2317 Hello! Thank you for your comments. I appreciate you taking the time to write to me. I have quite a few lessons on Pivot Tables here on YouTube as well as on my website - TheCompanyRocks. Please let me know how I can direct you to the best place to improve your understanding of Pivot Tables. Danny Rocks The Company Rocks

Asusisuful commented on 04 Aug 2012

Hi, nice video. About the Chart title, what if i want to show the date? i did according to your method, but the date came out with numbers rather than date. the date format is dd/mm/yyyy. the date is from a cell. for example. ="Date: "&A1 Cell A1 is dd/mm/yyyy

JoSags commented on 04 Nov 2011

If I have multiple items in the filter of my dynamic table, how can add all the selected ones in my title ? And thanks for the video.

Danny Rocks commented on 27 Mar 2012

WOW! That is quite the compliment - Thank you! I am pleased that you enjoyed my Excel tutorial. Danny Rocks The Company Rocks

Eric Sanabria commented on 23 Feb 2011

Thank's. Great job. i'm trying to learn more on "pivot table" from the very basic. thank's

Rosa Gouveia commented on 24 Sep 2012

Thanks a lot! your videos are the best Excel tutorials around here. I use them everyday.

13Sharms commented on 27 Mar 2012

Absolute awesomeness!!! Forget the chart legends, you are the legend!

James Perry commented on 13 May 2013

Thank u DANNY......2day i learned something NEW! Many Thank$

xinwei NIE commented on 25 Feb 2015

Awesome! Your video just made my day!!! Thank you!!!

Mitchell Cramer commented on 21 Jan 2013

Can this be done with Slicers?

Rosa Gouveia commented on 24 Sep 2012

I have the same question

TheGolddigger2 commented on 11 Oct 2012

that was the best ever

Suresh Mokamati commented on 11 Nov 2015

thank you ......:)

Excel Magic Trick 637: Lookup A Chart -- Defined Names, INDIRECT function and Formulas In Pictures

See how to lookup a chart using Defined Names, Data Validation List, and a formula using the INDIRECT function inside a picture of a chart. Select from the drop ...

User Comments

Guest commented on 03 Jul 2010

Hi ExcellsFun. Many thanks. I have resolved the problem!! What one has to do in 2007 is to: 1. Add any Smart Art Object.. 2. Select the inserted object and Click Cntrl A 3. Click a new cell and simply CLick PASTE from the home tab.. NB .. Not paste Special. 4. Delete the original Smart Art Object. 5. Select the pasted object and insert the formula... Follow everything in the video except for the copying and pasting of the picture... it works!! Cheers and thanks again for your time

Guest commented on 08 Dec 2010

Hi Mark, I have found a new way and much easier. You must have the Camera icon visible on your ribbon right at the top of Excel (you add it by clicking the "Customize Quick Access Toolbar)' button to the right of of the ribbon). Once you have the Camera visible and have followed everything in the video up to just BEFORE the copying and pasting of the picture (chart) then you are ready to use the camera. (follows next post)

Guest commented on 08 Dec 2010

So, instead of copying and pasting the image of the chart as shown in the video, simply click the CAMERA icon and then place you cursor where you want your changing chart to appear and click once. A small window placeholder thingy :) appears. Click that once and then enter the =PictureFormula in the formula bar and hit enter.... you should see your charts there.. Hope all goes well...

ExcelIsFun commented on 01 Jul 2010

I don't really know. You can't put formulas into charts. You can put formulas into pictures. So maybe the Paste Soecial did not work. See if you can insert a different picture and see if the formula will go into that one. Then tell me if that works. I just don't really know without actually messing and tesing the workbook itself...

1envivo commented on 01 Jul 2010

Tx for ur prompt reply. Everything worked as u instructed until 7'59, when I copy and special paste the 4th chart as picture into cell D7. You went up to formula bar and click in it to enter "=PictureFormula". Excel doesn't allow me to click on formula bar. Is there other way to put formula into pic? Thank you.

Guest commented on 15 Jul 2010

Hi, Am looking for info on how to lookup more than one chart simultaneously. I want to have a drop down list with years and then when I select, say 2011, then cash-flow, expenses, nett profit for that year display in their own charts.. can't seem to find anything like this.. hope you can help

ExcelIsFun commented on 15 Jul 2010

I am not sure how to do that. Try this site: mrexcel[dot]com/forum Also, you could use the new Excel 2010 add-in PowerPivot and then use four charts PivotChart and the new Slicers. Mr Excel at his YouTube site just posted about 13 videos about PowerPivot. Try those.

ExcelIsFun commented on 03 Jul 2010

I do not have an answer for you. Sorry. If it is important project, you can watch this video which shows how to do it with VBA: Mr Excel & excelisfun Trick 42: Lookup Picture In Excel Formula or VBA?

1envivo commented on 29 Jun 2010

Thank you for all these nice works and please keep it up, Does this work for 2007 excel? Cuz, in 8'00, I couldn't go for formula bar and associate to chart selector in cell D6. Thanks :)

Guest commented on 08 Dec 2010

These two post are back-to front so read them from bottom to top.. sorry but the text box does now allow too many charachters... :)

ExcelIsFun commented on 29 Jun 2010

Yes, itshould work in Excel 2007. I am not sure what you are saying about the 8:00 minute mark. Can you re-state your question?

gzlkn commented on 29 Dec 2010

@ExcelIsFun it is a perfect trick, thx for sharing this video. it will be definitely useful for my works. Thanks again.

AJMogsy commented on 01 Feb 2012

Thank you so much, I really appreciate all your tips and tricks; they have helped me alot! Thanks again.

ExcelIsFun commented on 03 Jul 2010

Thanks for the good information that many of our YouTube Excel friends will find benificial!!!

Amiram Dekel commented on 27 Jun 2010

thank you very much for teaching - this cool trick - this is amazing

ExcelIsFun commented on 08 Dec 2010

Read the other comments here - I think they will help.

ExcelIsFun commented on 27 Jun 2010

You are welcome! I am glad that you like it!

ExcelIsFun commented on 03 Jul 2010

Anyone else know what is going on?

ExcelIsFun commented on 22 Sep 2010

I do not know about that. Sorry :(

ExcelIsFun commented on 23 Nov 2010

I am glad that it worked out1

Mr Excel & excelisfun Trick 124: Dynamic Stacked Line Chart

Download workbook: //people.highline.edu/mgirvin/ExcelIsFun.htm See Mr Excel and excelisfun use two methods to lookup a column based on a date and ...

User Comments

sayefuts commented on 18 May 2013

Hi Dude, I dont know if you can remember that you had helped me with displaying multiple nominations horizontally by using small function.The formula was something like : IF(COLUMNS($G4:G4)>$G$2,"",INDEX($B$2:$B$10,SMALL(IF(Name=$F$2,ROW($B$2:$B$10)-ROW($B$2)+1),COLUMNS($G4:G4))))... Just Wondering if Offset function could be in place of Small Function and How??This question has been larking in my brain over the last one year.Could you be kind enough to help.. Best Regards SayefUTS

ExcelStrategy commented on 17 May 2013

The trick of pasting the names of the dynamic ranges in places of the references inside the data-boxes of the chart it's sooo brilliant ! It goes directly in my repertoire ! Ps I don't know if that can help but when I have to type the ":" to avoid the annoying double reference I simply pres the F2 key to exit the "point-enter" mode and enter the "edit" mode :) (ok not so brillian but very effective !) :)

Raj Kumar Kothari commented on 18 May 2013

Hey Mike....I have a few named ranges in a sheet but some now i am not getting them to work inside a chart using the Indirect Function to make the chart dynamic.I am trying to refer a cell inside the chart containing a dropdown list of all the Named ranges.

ExcelIsFun commented on 23 May 2013

three sections of custom number format; positive;negative;zero;text Check out these video titles for details: Slaying Excel Dragons Book #36: Custom Number Format & the TEXT function Highline Excel Class 27: Custom Number Format & TEXT function

John Jingle commented on 19 May 2013

Another way to do it is: Make two dynamic ranges using offset and count. Then make a third range which has #n/a for every value in the range. Then just hide the line and markers of the third (dummy) range.

Khurram Muhammad commented on 28 Oct 2013

If may seem off track to ask this here but here goes: I'm amazed wid the way Live Tiles work in Windows 8. Is there anyway v can hv random data info represented in similar format in excel?

krn14242 commented on 18 May 2013

Points to Mike for dynamic ranges with the index function. Use this a lot now, makes growing charts much nicer to look at.

ExcelIsFun commented on 18 May 2013

Cool! You are an amazing Excel Master, krn14242!!! (How far we both have come with Excel over the years!)

chunkit721 commented on 23 May 2013

Hi guys, I would like to know more about the triple colon trick at 1:43. Can you explain a bit more?

Mike Killpartrick commented on 21 Jul 2013

Hardly dueling it's annihilating but good on you mr excel anyway you have some good stuff sometimes

ExcelIsFun commented on 18 May 2013

I would consider using AGGREGATE instead of SMALL, but OFFSET? What is your thinking? Why OFFSET?

PleaseStop AskingIWIllAppreciateIt commented on 20 May 2013

thank you for these videos guys, really appreciate what you are doing here

ExcelIsFun commented on 18 May 2013

I am not sure. Try THE best Excel question site: mrexcel [dot] com/forum

ExcelIsFun commented on 23 May 2013

Three sections of custom number format: positive;negative;zero;text

ExcelIsFun commented on 17 May 2013

Totally what I was looking for: F2 before typing colon!!!!!! :)

Krishna KLV commented on 18 May 2013

Hi Mike this is very interesting thanks a lot

ExcelIsFun commented on 18 May 2013

I am not sure how.

ExcelIsFun commented on 20 May 2013

Cool! Very Nice!

ExcelIsFun commented on 18 May 2013

You are welcome!

Dynamic Range Name in Chart - Advanced Excel MIS Training Course

For More Details Log on www.iptindia.com and Call - +91 8826828093, +91 9968811487 Skype ID - advexcel1 Mail us - [email protected].

Excel Dynamic Chart #15: Array Formula & Table Nomenclature for Top 10 Wrestling Score Chart

See how to make a dynamic chart that shows the top ten wrestlers names and scores using an array formula, Excel 2007 Tables Feature with dynamic ranges ...

User Comments

ExcelIsFun commented on 24 Apr 2011

Unless you are an advanced user when is fluent with array formulas, I would not do this. The best method is just to use Filter, then copy and paste. Try the videos I have on Filter: Office 2010 Class #35: Excel Sort and Filter (Data Analysis) - try at 6:42 minute mark youtube [dot] com/watch?v=hOWBTLCnGKk But you will need to filter the number column and do the "top 10 filter" In fact, the Filter method is MUCH MUCH easier than the formula method and is a very common method

Jason Protheroe commented on 13 Mar 2012

@ExcelIsFun My reply doesn't seem to have appeared so thank you again for the fast reply. The problem was actually with a formula in the source cell. I have another question to this formula. How could it be changed to show the absolute top ten. So with the example from the, if there was a entry of -120 I'd like that to appear at the top

Jason Protheroe commented on 09 Mar 2012

@ExcelIsFun Thank you for such a fast reply. As is typically the case a while after posting. The cell it is connecting to is part of an array that is pulling out the top ten numbers associated with a criteria. I fixed it by changing the reference to the dynamic range in the table rather than the actual cell reference.

Jason Wallace commented on 07 May 2013

Been trying this all day and I feel as though the table nomenclature has changed or is different for Mac 2011. When I go to put in the INDEX(wt[name]... it doesn't recognize the square brackets? So I have to put the full formula in for INDEX and it tells me I've got too many formulas.

Jason Protheroe commented on 09 Mar 2012

This is exactly what I was looking for. Followed the process to the letter but I result that I get oin the cell is a 0. I've gone through the formula evaluation, and it is pulling out correct row number. I've obviously done something wrong but I don't know what. Any ideas?

ExcelIsFun commented on 06 Apr 2011

If you are taking an Excel class, I can't imagine that they would have you do something this complicated. In your class, do they teach advanced excel techniques like this? If they are, then cool!! I am glad that the video helped!!

ExcelIsFun commented on 09 Mar 2012

@prothja1 , I am not sure. Zero usually means you have a zero in the cell or it is looking at an empty cell. It is hard to know unless one looks at the formula. You had all the right columns? You did Ctrl + Shift + Enter?

margaritanmambo commented on 08 Nov 2012

This has been so very useful! Could i do something similar and extract the bottom 50 results in a separate table? Or extract the bottom 20%? i look forward to your reply! Thankyou! xx

Kkip I commented on 19 Sep 2012

It is a great video. However, would it be possible to choose the beginning date and ending date and display the top 10 list during that period of time?

ExcelIsFun commented on 24 Apr 2011

I do not have an idea to give you to research. Best to post your specific question to THE best Excel question site: mrexcel[dot]com/forum

Jon Dow commented on 15 Jun 2012

How would you take this graph and show the best scores at the top of the chart instead of at the bottom? Thanks for your videos!!

ExcelIsFun commented on 10 Feb 2010

Click before equal sign, type space type enter. Then to un-suspend the formula delete the space before the equal sign.

ExcelIsFun commented on 15 Jun 2012

Instead of ROWS(G$8:G8) in the second argument of LARGE, try: ROWS(G8:G$17)

ymeaga1n commented on 10 Feb 2010

@4:20 How do you suspend the excel formula? That would be useful!

ExcelIsFun commented on 02 Mar 2012

@searingtouch , I am glad that it works!! It is a useful trick!

Itz_M0DZ commented on 06 Apr 2011

you are amazing this saved me from getting a shitty grade :D

ExcelIsFun commented on 08 Nov 2012

Try using the SMALL instead of the LARGE function.

Link for boards:

Link for your site:

Current link: