| by Kenneth Chase | 100 comments

This Excel Chart will grab your attention (Infographic template included)


In this lecture, I’d like to show you how you can create a non-standard Column chart or an info chart in excel like this one some time ago Udemy published a very informative and interesting report that had this chart in it which grabbed my attention And I was like wow, I really want to make this in excel That’s what I’m going to show you how to do in this lecture. The thing I like about this chart is that it’s informative, It’s also visually appealing and it’s different to what people are used to seeing – so they pay more attention Now this chart…. This is something that people are used to seeing. Some of you see this every single day It is visually effective because it brings attention to the key chart elements that need emphasis, but if I put this side-by-side Which one grabs your attention more? For me personally – this one definitely grabbed my attention. I wanted to create it in excel in a way that is also dynamic So it saves you time whenever new data comes in. Now the highlighted part the part that’s conditionally formatted, is something that I also wanted to make dynamic depending on the condition. In this example, I have some random data and the number of users per weekday that are logged into the system And I want to highlight the weekday that has the maximum number of users logged in So if I get new Data and Tuesday happens to be 600 everything will update automatically First I’ll show you how to get this dynamic conditional formatting effect And then I’m going to show you how you can bring shapes in charts And finally how to tweak them for optimal effect because we don’t want to have stretched out shapes So let’s start with the conditional formatting part This is the data table which we’re going to use to create our amazing chart We have the number of users per weekday, [and] we’re going to start off by inserting a very basic Column chart Now let’s just make [some] minor adjustments. So remove gridlines remove axis, add data labels Let’s Decrease the Gap width so that they’re closer together. Let’s go with 70% I’m going to update the title so that basically equals this Take away the border. So I have this in [my] quick access toolbar [and] that’s the outline if you don’t have it you can get to it by Going to format and removing the shape outline from here, so while I’m here. Let’s also change the shape fill To grey. That’s the basic chart now I want to conditionally format this so that the weekday that has the most users becomes automatically another color if I were to do this manually so here Thursday has 500 right I could click again on it and Change the shape fill of only this one Category to green but it’s not dynamic because if Tuesday is 600 This is going to remain green and that’s not so what I want to happen. Is that this one becomes green and this one Thursday turns back to grey Now here’s the key that whenever you want to Conditionally format anything in your charts you need to add a new data series What I’m going to do is add a data series that basically consists of only one Bar and that bar is only going to pop up whenever I have the maximum so basically everything else is going to be zero but only There where the maximum number is I’m going to have let’s say a green bar. I need a new series The series is going to have zeros and that maximum number, but that maximum number has to pop up adjacent to the Category, so [my] formula is going to be if this equals the Max of this data set I’m going to press F4 to fix it because I want to copy it down if That’s the case then give me back this number, so if that’s a maximum otherwise give me zero And let’s copy this down so that’s my max series, so I’m going to add this to my chart by going to select Data add That’s the name of the series always always include the series name in your chart otherwise you’re going to mix them up and That’s that so it’s plotting it beside it But that’s something I can [easily] [change] So I’m going to go here to series option make sure that I select [the] whole series and I’m going to change the fill color first to a green and Now we’re going to go here and for series overlap you see there are minus 27 That’s why there’s a bit of space between them. I’m going to change it to a hundred percent So now this one is on top of the other series The order of it is basically defined by this [see] if I push this one down See the gray is covering the green if I push it back up The Green is covering the gray but for the other [datasets] is all zero That’s why this gray is the only one that’s being covered by the green This is fully dynamic because if I change Tuesday to 600 – it jumps. So that’s the first step now How do I bring shapes to the chart, so how do I change the shape of this to something else? So let me just take a copy of this and paste it here From insert shapes I can pick a shape [that] I want I Want to have the one that is a bit rounded at the edges That’s this one Just draw it out here. You can turn it around and change the color to my grey The Shape Outline to nothing – just take it away That’s the shape let’s say that I want to use all I have to do to replace these bars with this one is to go Control C. On [my] shape click on the bar Make sure the entire series is selected so also the one behind this green one and go control V To get the green one [I] have to add that [to] the second series because remember I have two series right so if I want my second series to be green and this shape I Have to add that [to] the series as well okay, so I’m going to change this to [the] green and [CTRl] C Click on the maximum series. That’s the one that’s highlighted and go control V so now I’ve added shape to chart, and it should be dynamic, [so] let’s go and change Tuesday back to 300 [ok] jumps back as well, but you see what the problem is here for the data sets that are bigger So here for 500 the shape is really Pointy and here, it’s not So basically it gets stretched out like this For bigger data sets and becomes like this for smaller data sets That’s something that I want to avoid to do that. I need to [use] a trick and the trick is to Basically to split each of these data sets so the 400 to two data sets The top Data set is going to be identical for [all] of them And that’s going to be let’s say this shape and the bottom data set is going to be a shape that doesn’t mind being stretched out, and that shape is a rectangle to [add] 2 data series to this I could [use] a stacked Column [chart] That means I just have to change my data set a little bit. I’m going to copy this part Paste it here Let’s not make you too complex for the beginning I’m just going to do the gray series first and then at the last that we’re going to add the green series to it Okay, so I need to have two sacks Let’s call them stack one and Stack two That too is going to be a number That’s common to all of them right [so] that can [be] the minimum of this data set I’m going to fix it [and] now depending on my data set I could adjust this even more I could go – If I find that this doesn’t really represent my shape quite. Well, it makes it squash that I can change this [number] that’s the size of my top stack now my bottom stack is basically going to be my Original value [minus] my top stack I’m going to copy that down Okay, so let’s insert this chart. I’m going to highlight this hold down control highlight this and Insert a column chart, but now a stacked column chart So this is our top stack they all have the same size so we don’t have the problem of having our getting stretched out You’re just adding the title taking these away and let’s reduce the [gap] [flip] again I’m going to reduce it even more here. Let’s go to [fifty] Okay, so I need two shades. That’s my shape number one My shape number two is going to be the rectangle down here Let me copy this first and click on this paste That looks good [so] [I] can either bring in a rectangle [shape] here But since this already seems in sync with this one, I can just change the color of this to the same color Now what about the data labels? Well, I have two stacks here right in this top stack I’m going to highlight them right mouse click and add data labels to it Let’s make them stand out make them white Bold and let’s get them to be bigger But the data label is not showing what I want to show right is showing the size of this stack So that’s not what we want. [I] want to show basically the value from cells and the value that I want to show is this So if you have excel 2013 or excel 2016 you can do what I’m doing right now If you have an older version of excel like excel 2010 and seven what you have to do is click on each of these data labels and connect them with a formula to your data Okay, but it’s doable it. Just takes a bit longer Take away the border of this one want to do is bring in the Axis labels [on] top of each of these bars so I can remove the axis completely How do I do that because that’s not a part of the axis options? You always have to leave the x-Axis on the bottom you can’t bring the labels up there But you can use a trick and the trick is remember we had a stack right and the bottom stack can also have data labels so I can activate them and I can adjust their positioning so that they’re on the bottom inside base And now all I have to do is do the same trick and use value from cells, but now instead of showing actual numbers I’m going to show my axis labels and Remove these two so again let’s adjust the formatting That looks really nice. It’s very harmonized so as a next step. I’m going to get my conditional formatting in there What I have to do is exactly what we did in the first step here where we added a max series We need to have another stacked Column chart in here That’s going to cover our gray snack if that stack happens to be the maximum So let’s call it stack one Max and back to Max I’m just going to move this a little bit out of the [way] Okay formula is the same we need to check if this number equals the Max of this series press F4 Then now not show the number but show the value of Stack one otherwise show zero That’s for Thursday now. I’m going to just copy this press escape Paste this here, and just move this one to stack two because my east condition is basically the same So now I bet I have my series. I need to bring it in my chart right mouse Click select Data and Don’t forget to series name series values of my first [pack] is this Add again or you can see it popped up right on top So that’s my second stack for the max, and that’s the series values so press [enter] Like that so that looks a bit funny, but basically it’s a stacked chart right so whatever I’m adding to it It’s going to add it as a separate snack on top. I don’t want it to add on top I actually want it to cover it So now layering this by 100% is not going to work in a facts Column chart Right because the series overlap is 100% what I can do instead is to Change them to only these two stacks to the secondary axis So just came back to the change chart type because I can do them quickly here So that’s the fact one [max] and stack two max see now it covered it And the good thing about this is that this is a mac series that I’m putting on the secondary axis [I] have that same max on the primary axis I don’t have the problem [of] my access my secondary and my primary isis not being in sync They are going to be in sync. [so] [now] I can remove this and For this well the green that’s the green that I had I think Is just double check should be this one now all I need is To change the tip of that I’m going to cTRl C this to this shape So that’s not too much the whole stack to Mac series is highlighted and I’m going to paste it there that looks nice So let’s test this I’m going to change Monday to 500 as well Let’s see what happens well now I have two maximums and now let’s change Tuesday to 600 that one becomes green That does take some steps But you just do [the] [setup] once and you can use it on different data sets Let me just bring this up, and we can do a quick direct comparison with our first chart This compare to this is in conspicuous trade this one really stands out the first time I saw it I was really attracted to it, and then I was like wow. It’s actually easy to read as well So that’s how you can set it up in excel Now remember you can use this on any set of data that you want I suggest that you don’t overuse this type of chart use them with care in special reports and in dashboards if you like this type of excel Tutorials make sure to subscribe so you don’t miss out a more advanced excel technique that I’m going to share with you This technique is a part of my upcoming – book course that’s coming out on [unity] in about two months time So do check [it] out because it’s going to have a lot of neat techniques in there

100 Comments

Victor Odoyo

May 5, 2019, 10:03 am Reply

How do you create chart in power point

Ralph Edenbag

May 5, 2019, 3:11 pm Reply

Clever work, for sure !

Satish Kumar

May 5, 2019, 12:24 pm Reply

Awesome trick …

Jola Andile

May 5, 2019, 7:47 am Reply

Hi Leila

Thank you so much for sharing these amazing tips. I subscribed immediately after seeing this video.

I encountered a problem when I have one small value on my data for an example if there are 50 users on a Tuesday, the information on the bar chart is not readable.

Are there any tips that you can share in order to cater for such occurrences.

Rania Hamid

May 5, 2019, 6:53 pm Reply

You are an excellent teacher. Perfectly paced, incredibly relevant and clever. I've never hit the subscribe button so fast before lol

AjAz Rohilla

May 5, 2019, 11:11 pm Reply

Awesome, you have made it so easy and colourful

Ka Sus

May 5, 2019, 9:09 pm Reply

As always….. I liked your video!

GPMGify

May 5, 2019, 6:26 am Reply

Wherever I work I’m considered the Excel Guru. But watching your videos makes me realize that I can still learn so much from you! If YouTube wouldn’t exist, it would need to be invented just to show your videos!
Plus: your teaching skills are phenomenal! Your voice is so easy to follow. I can’t see the slightest room for improvement as your classes are simply perfect!!! Thank you Leila!

Shakeel Ahmad

May 5, 2019, 7:22 am Reply

Looking nice.

Ramesh Nayak

May 5, 2019, 8:06 am Reply

Congratulations !!! you are the only you tube video maker who shared even the video details (camera, lights and sound) . I was looking for it to make videos to my students in college. Could you please name the devices used in the description itself. The links provided are not working here. Thanks

corey davis

May 5, 2019, 1:37 pm Reply

Excellent. I have only watched a few videos so far, but you have given me several new tools for my Excel toolbox. I love your very natural way of teaching how it works while showing me what to do.

Stéphane Brizoua

May 5, 2019, 6:32 am Reply

Hi leila : really amazing chart ! Thanks. But I have an issue when applying to data positive and negatives. Can you look at it (if possible)

Ali Shoki

Jun 6, 2019, 7:02 am Reply

I need small portable software or macro / power query solution to merge excel worksheets from multiple files in a single excel (master) file accordingly to their worksheet name.

– First unhide all rows and column and then Delete blank rows / column of the source file before copy.

– If the worksheet already exists in the master file then it will insert (merge) data / rows below to existing data row in the master sheet with the similer sheet name or if not exist then will create new sheet and insert data as per source file rows. (its mean that Master file should have all sheets data which all source sheet files have)

– It will not analysis /compare column title / header or any data, but will

– Copy and Paste Special Value from 1st row / column till end (row by row) from the source file to available lower cells of Master File sheets like a manual task.

– While inserting each row, It will add file name in the first column. (similar to Microsoft Power Query). for better row by row tracing / rechecking .

https://business.tutsplus.com/tutorials/how-to-combine-excel-spreadsheets–cms-30397

– There should have number selection option for how many rows escape from up / start from all source sheets (which is always “Header row / title”) while copy and pasting in the master file from source data. by defualt it would be (0). In this way the user will have option to copy data with or without header/s.

In short, simple procedure and with only one above row escape option, it should work as a manual system. Just copy row by row from one sheet to master sheet without compare / any analyzing work.

Hope you will help me to give a solution in this regard.

Regards,

Ali Khan

[email protected]

Mark M

Jun 6, 2019, 4:36 pm Reply

I had to watch this a few times to get it, but wow, what a terrific looking chart it makes.

Edz Ward

Jun 6, 2019, 1:23 pm Reply

Wow! I usually don't work with Excel charts and I have no idea why this video showed up on my feed. But I'm glad it did. Awesome chart!

Daniel Menezes

Jun 6, 2019, 2:45 pm Reply

Very few likes for a great idea and execution!

Alfred Taylor

Jun 6, 2019, 9:42 pm Reply

I have a question. How can I insert the current date into a cell without it automatically updating. The today function won't work, and I can't get Excel's calendar function to work. Do you have any suggestions? By the way, I love your channel.

Madaliso Shonga

Jun 6, 2019, 12:57 pm Reply

Microsoft can you please employ Leila so that you can work together to add this feature at a click of a button

Nick Firoozmand

Jun 6, 2019, 2:13 am Reply

Hi Leila, can you please explain whether it is possible to have data trends on two "scatter with smooth lines" graphs to show the "difference" as apposed to the actual values?

Nick Firoozmand

Jun 6, 2019, 2:44 am Reply

Hi Leila, I just watched your video to the end and realised that you've already answered my question, using data labels with "value from cells"! thanks much for the time you put in creating such amazing videos!

Nurjan N

Jun 6, 2019, 10:20 am Reply

wow, thank you for simple explanation step by step and showing the logic of how it works

Mohammad Hashim

Jun 6, 2019, 3:20 am Reply

It’s very useful to make dashboard

xuebing xian

Jun 6, 2019, 2:52 pm Reply

it seems my excel 2018 doesn't have the "Values from Cells" when I was trying to change the top number from your 125 to the real series. Does anyone have the same case??

edificetv Gospelarena

Jun 6, 2019, 3:17 pm Reply

amazing
Your video rocks!!!!!!!!!!!

Raju Joglekar

Jun 6, 2019, 3:25 pm Reply

Great work. Gratefully yours

Maheshwaran M

Jun 6, 2019, 6:39 pm Reply

Hello …Pl share video for Gantt chart

René Fischer

Jun 6, 2019, 10:13 am Reply

Thx a lot for this awesome presentation. I can not wait to try by myself, but i am curious what would happen for usernumber smaller than stack 2. Did you try this?

Jorge Zavala

Jun 6, 2019, 1:18 am Reply

i was so happy to finally know how to make this charts!! thank you so much

anand sundar

Jun 6, 2019, 10:15 am Reply

Leila could you upload a complete video on excel power bi.Thanks for sharing all your videos are wonderful
for learners from basic to advanced

Muhammad Fadil Rizqullah

Jun 6, 2019, 11:17 am Reply

straight on hitting the subscribe button once finished watching this video. keep up the great content to educate us please!

Garth Shaner

Jun 6, 2019, 4:13 pm Reply

This is great! Love the (relative) simplicity of how you made the boring chart eye-catching!

Mad Clown

Jun 6, 2019, 4:18 pm Reply

Looks like a headstone

ATUL PATEL

Jun 6, 2019, 4:19 pm Reply

Thank you. I use a lot of graphs. It does seem a lot of work in the beginning.

Johanny Jacobsen

Jul 7, 2019, 5:03 am Reply

Wow! I also agree that this is the BEST Excel Toutube channel ever

murthy mp

Jul 7, 2019, 2:22 pm Reply

Nicely explained !!

Acheiropoietos

Jul 7, 2019, 7:40 pm Reply

So clever. I have been using Excel for 20+ years and this never occurred to me. So happy I found your channel!

varunaja

Jul 7, 2019, 9:15 am Reply

Thank you, really helpful

eduardo rodriguez

Jul 7, 2019, 3:18 pm Reply

I want to know who are the losers who downvoted this?

SAJAD MK

Jul 7, 2019, 4:51 pm Reply

Dear madam …after certain column how to automatically jump to the next row..if A1,B1,C1,D1 are data entry area I want to automatically jump to A2 and same process should be continued..please help me

dina ahmed

Jul 7, 2019, 9:49 pm Reply

Amazing thanks alot

rickyroko1

Jul 7, 2019, 6:13 pm Reply

This was more of a problem solving video tutorial exercise than a excel exercise wow!

behrang chaloushi

Jul 7, 2019, 3:41 pm Reply

YOU ARE AMAZING

riz man

Jul 7, 2019, 10:57 am Reply

Amazing, loved it, whenever i need some help i get back to your channel.

jnormanton

Jul 7, 2019, 10:59 am Reply

I first started watching you because you are so beautiful now I watch because I learn so much.

Mohammad Thalha

Jul 7, 2019, 1:44 pm Reply

Hello Leila, Great admirer of your work. Just had a question on the above trick. So, you created a new column C ( Max )to the TABLE and added that data series to the chart. I'm not able to add the new data series to the chart when it is PIVOT TABLE. The option ( new ) in the " Select Data source " is grayed out.
Please help?

Trupti Patel

Jul 7, 2019, 2:19 pm Reply

Leila, amazing !!! can you show how to create Excel time sheet and schedule please ?

AVIJIT kAR

Jul 7, 2019, 4:38 pm Reply

i love it

Tom Cruise

Aug 8, 2019, 8:08 am Reply

Thanks for a good video!!! l love it!!!

Nadir

Aug 8, 2019, 12:41 am Reply

Thanks for video!

V Shravan kumar

Aug 8, 2019, 3:28 pm Reply

Great video….OMG really don't know that we can use charts in such way.
Awesome…keep rocking as always.

Vijith Nambiar

Aug 8, 2019, 6:04 pm Reply

Amazing ?

Funkykid

Aug 8, 2019, 8:10 am Reply

Finally Excel is getting exciting for me thanks to your Explanation!

ANADER SRSEQ NORD

Aug 8, 2019, 4:38 pm Reply

I hope you keep going to help us …let's GOD bless you too much

Rajaraman vilvakumar

Aug 8, 2019, 4:32 pm Reply

It is great helpful to whom will be utilise his scope of works ,THANKS

Tom Gooch

Aug 8, 2019, 9:27 am Reply

Hi Leila, this is fantastic. I am having one problem though. And that is when I try to change the shape by copying over the chart shape, it seems to keep the original rectangular shape in the background. Any ideas?

Paul Richards

Aug 8, 2019, 2:41 pm Reply

Will this work correctly if someone opens it in an older version of Excel like 2010?

Karen Hutchinson

Aug 8, 2019, 4:58 pm Reply

Hi Leila, thanks for yet another fantastic video. Very clear, and easy to follow. I've learned lots from you, thanks.
I have recreated your graph using Excel 2007, and it works really well.

Resin Expression

Aug 8, 2019, 8:38 pm Reply

Hello, thank you for your videos. We have a specialty paint company and produce sample boards to show possible color combinations. We do not want to repeat the combinations. We have 60 colors in total. We see that excel will tell us we have a duplicate if it is entered in a specific order (or the same order) but is there a way it will identify if the colors are listed in ANY order?

Suhani Yadav

Aug 8, 2019, 1:44 pm Reply

leila me leila ….aesi hu leila…

Brigh N Quisitive

Aug 8, 2019, 5:03 am Reply

You're the best that's ever done these. I've learned loads. Thank you

MuShahid Ali

Aug 8, 2019, 5:13 pm Reply

You look very nice to me and I like you

Trishal Dhawan

Aug 8, 2019, 8:47 am Reply

Leila, I love your excel videos very much and it is helping me alot. I have also done many excel works

Owor Benard

Aug 8, 2019, 4:23 pm Reply

The best video I have watched on youtube in years

Patrick James Robles

Aug 8, 2019, 12:39 pm Reply

Where have you been all my life! Thank you.

William Taylor

Aug 8, 2019, 2:55 pm Reply

Has anyone had luck getting the MAX bar to work with a PivotTable or something that will generate a dynamic # of bars every time?

P.T. VENKATESWARLU

Aug 8, 2019, 8:28 am Reply

How to write Physics formulas
Topic – Thermal properties of the matter
Example: P1/P2= ( T1/T2) whole to the power of 4
Which APP is necessary?
Please make a video in Word, Excel, PowerPoint

Cristian Paius

Aug 8, 2019, 9:21 am Reply

Plecase help with a formula ,or haw ca-n I insert data în a row in a specific cell If a have in another row dame data

Ahmed Mousa احمد موسي

Aug 8, 2019, 12:17 am Reply

thats great

Shuska

Aug 8, 2019, 8:59 am Reply

Hi Leila, great tutorial. But how do you use this Min/Max Chart, when your original data comes from a Pivot Table? And additionally to that the Pivot table changes in size? I have monthly sales data for several years, and I would like to highlight the columns with max monthly sales and the min monthly sales within a given year (chosen with a slicer). However, the last financial year does not yet contain sales data for all the 12 months but only for 8 months. Do you have any advice about that?

Avinash Patil

Aug 8, 2019, 4:20 pm Reply

Hi, this might be a stupid question but just wanted to know. How can we save excel workbook as a web page keeping the charts intact and viewable on browser

Michael D

Sep 9, 2019, 8:44 am Reply

Wow what a great tutorial! I've started implementing these kind of visualisations into my dashboards at work and they've been really well received. Thank you so much!

david hodgins

Sep 9, 2019, 1:54 pm Reply

Hi Leila.
Im wondering if it is possible to have, say 10, sheets in an excel workbook that you want to create charts for.
However, the charts are to appear on the 11th sheet – dependant on which sheet is selected via a dropdown box.
I enjoy your tutorials, very clear, consise and well presented, thank you.
Dave H

Deanna Spinelli

Sep 9, 2019, 12:15 am Reply

This is great for a chart with only one type of data source, but is there a way to create this using multiple types of data, for instance a Benefit vs. Cost data chart?

Michelle Woods

Sep 9, 2019, 11:00 pm Reply

Can u make a similar tutorial for decimals instead of integers?

John Houllahan

Sep 9, 2019, 3:01 am Reply

Can I use this with a pivot table?

Shofiqul Islam

Sep 9, 2019, 11:40 am Reply

i couln;t open your exercise file, anybody can help me anyway

Michelle Austin

Sep 9, 2019, 11:54 am Reply

Really great tutorial.

Enga Hrahsel

Sep 9, 2019, 10:50 am Reply

i have been watching your videos lately, there is onething i need to know.. i want to plot a graph for every mark obtained by a student. can i do it in one dynamic chart. i have the following criteria.. academic session, class, subject .. or is there anything i've missed.

Thuan Tam

Sep 9, 2019, 1:42 am Reply

love vidoes and love you. many thanks from vietnam!

alfadol hassan

Sep 9, 2019, 7:03 am Reply

Thanks Ms.leila
How could be active option F4 fixed in my laptop?

officerdick27

Sep 9, 2019, 7:57 am Reply

Is there a way to do this with Pivot table data? add the additional Column, with the "if(***=max(***),1,0)"?

Orange Slide

Sep 9, 2019, 6:16 am Reply

Thank you! Followed this video step by step and made a nice chart.
Although I think it is 'too much work'. I'd rather redo that hightlight step in Powerpoint or PS. If I really need a dynamic highlighted chart I may try Power BI.

H Nakibapher Jones Shangpliang

Sep 9, 2019, 5:04 am Reply

This channel just amaze me about what Microsoft has in store that I previously never knew of… Thanks for the tutorials…

Tee Tilla

Sep 9, 2019, 11:48 am Reply

Absolute genius-level creativity. And looks fab to boot.

qamar zaman

Sep 9, 2019, 7:11 am Reply

Make a vedio on sale purchase riceving and paymint cash book

Karla de la O Serrano

Sep 9, 2019, 4:16 pm Reply

You’re a true Excel wizard 0__0

Harindra Devadiga

Sep 9, 2019, 3:15 am Reply

Hi Madam… Can you please take a classes of VBA for me

Omar Alsharif

Oct 10, 2019, 6:02 am Reply

Sweety Leila
I can't express in words how much you are awesome. You are amazing. So many thanks for the outstanding presentation.

James Lau

Oct 10, 2019, 3:36 am Reply

awesome excel tricks!

Ramesh Soni

Oct 10, 2019, 1:24 am Reply

Wow. Thank you.

Gabriel K

Oct 10, 2019, 11:27 am Reply

I have two lists . If LIST B IS ONLY APPLE FOR LIST A ID'S THE COUNT SHOULD BE 1. IF LIST B HAS OTHER THAN APPLE or APPLE FOR LIST A ID'S THAT SHOULD NOT BE COUNTED. PLEASE HELP

List A List B COUNt OF ONLY APPLE FOR LIST A ID's ARE : 4
111 APPLE
111 APPLE
111 APPLE
111 APPLE
112 APPLE
112 ORANGE
112 GRAPE
113 GRAPE
113 ORANGE
114 APPLE
114 APPLE
114 APPLE
115 APPLE
115 APPLE
116 APPLE
117 ORANGE
117 APPLE

Lorna Marie

Oct 10, 2019, 4:55 pm Reply

I appreciate what uv done but that is a lot of work gf

Ayxan Salmanzade

Oct 10, 2019, 6:48 am Reply

Very useful! Many thanks!

Sujit Kumar

Oct 10, 2019, 8:05 am Reply

Hi Leila, information is quite useful for building graphs however have one small clarification, I am using Excel 2007 and when I create stack chart and add the shape on the 2nd stack and then assign same color to both stack 1 and stack 2, shape doesn’t blend there seems to be a separator between the two shapes. How to handle this ?

Ud Din

Oct 10, 2019, 9:35 am Reply

You are superb !!!

Sebastien Frederic

Oct 10, 2019, 5:50 am Reply

Amazing!

Sebastien Frederic

Oct 10, 2019, 5:50 am Reply

Thank you!

Manideep Karthik

Oct 10, 2019, 7:49 am Reply

Seriously..!
You can do all these with excel ??

nuc leus

Oct 10, 2019, 7:30 pm Reply

Dear,
All Time best your Channel about XL

David J. Ferrick

Oct 10, 2019, 10:47 pm Reply

I use the method of conditionally highlighting chart elements all the time and it really does grab the attention of the audience.

Leave a Reply