Sort Chart Notice For Free

welcome back this is Excel video 471 and I'm Nate Moore talked to a group today that said hey Nate can you help us manage our schedule better we've got these anomalies in the schedule docs with early starts or not taking lunch or whatever can you gather that information and tell our clinical folks so they can plan ahead the answer is absolutely and I'd love to do the same for your practice when you're ready I want to play with something different today I've got a little chart here that's got asthma diabetes and hypertension I'm looking at new patients or whatever and let's say I want to change the order of my asthma diabetes and hypertension it's in alphabetical order now what if I want to change that two ideas first idea is if I let's just grab a copy of this rather than butcher what I've got going here if we copy this and then from the Home tab we format it as a table Yeah my table has headers let it do its thing and remember it gets worked up about that but I'm not terribly worked up about it we'll call this disease maybe that works if I do this and then from the insert menu let's do a similar chart I've got asthma diabetes and hypertension if it bothers you that the years are down here in the legend instead I can always switch roll and column and now I've got asthma diabetes and hypertension whoops I just got rid of the chart title oh well just like that put the chart title back more or less where it goes and if I wanted to change asthma diabetes and hypertension one thing I can do is since this is a table it's easy for me to sort Z to A and now I'm going hypert hypertension then diabetes and Asthma that's one way to change the sword ORD is put the data in a table another advantage of having the data you want to chart in a table the challenge is if I want diabetes first for whatever reason that's my that's my biggest issue or that's the place I want to focus on or my payers are after me for that or whatever what you can do let's come back over to this chart here and drag this chart down just for a minute so this is this data yep what you can do is change the plot order now notice when I click inside let me click out and click in Click inside the chart now Excel knows where my data is and I can do my drag tricks if I were to add 2016 or if I were to add another disease I could drag and add more data the downside of the shortcut I'm going to show you now is this ability goes away when you do this if you go to the design Tab and you say hey I don't want to be copying and pasting my hypertension diabetes data around I want diabetes first you can always go to select data window and from here what you can do is these up and down buttons will change your sword order so if I want to dius first I could do that then asthma hypertension or I could move asthma down or up or whatever notice this as soon as I use these arrows I lose my chart data range here let me go back and show you if we come back to select data I've got a chart data...