Let me just add it in okay yeah okay yeah that's that's it there you go you.
Didn't just do that is this how you've been creating a report for the past weeks yeah it's a bit of a pain but I've Gotten Good at estimating the location so don't worry the ruler helps okay so.
You picked the wrong thing to be good at you can make that line Dynamic and add it to your chart step aside let me show you okay so there are different ways of doing this but I'm just going to show.
You the easiest way first thing you're going to want to do is to transform this data into a table so the moment we have more sales managers and more data the chart is going to update automatically.
Target this is going to equal this press F4 to fix the referencing and now we have our series added okay so your line wasn't really straight but your estimate it was pretty good now we obviously.
Don't want these to be columns so we're going to right Mouse Click Change series chart type for Target in the combo section here let's switch it to line there we go we have our line click on OK.
And we have our line Dynamic okay I'm going to remove your other line the great thing about this is that it's automatic if this changes to 150 updates if it's 300 updates I'll just put it.
Back to 280. now actually we can even improve this further let's press Ctrl 1 to bring up the settings go to line options and let's add an arrow here I want to make it thicker and the ending.
Part should have that too now this looks a lot better okay we could also add the target directly to this I'll add it to the first point so I'm going to select to add data labels.
Posts Related:
But I don't want the data labels to show - Make Automate
Up everywhere so I'm going to click again just to select the first one right Mouse click add data label now click click to only select this one press Ctrl.1 to bring up the settings or if you double click it's going to come up scroll down show it on the left hand side that looks good I actually want to make it bold and let's make it bigger.
Okay we don't need this either delete and take a look at this beauty and yeah if you don't want anyone to see this target series you can just hide it or better let's group it I'll use the.
Shortcut key shift alt and the right arrow key now we have this group together but notice the line disappears don't worry right Mouse click select data hidden and empty cells we want to.
Show data in Hidden rows and columns and our line is back what so next time all I have to do is add the new numbers and everything updates automatically yeah so I know it's hard to tell but next time.
You find yourself doing weird stuff in Excel just ask [Music] I'm so happy with the automation you have no idea look at this I just paste.
The latest values in update the target and I'm done yeah so higher ups want a bar chart Instead This column chart is getting too wide for them with all our new sales managers so please switch to a.
Bar and add that Target line the meeting starting in like five minutes so be quick no problem let me just do it um just quickly gonna insert a bar chart so let's just highlight.
Where's my insert here create a bar that's it right here it was this one right that's my target line right Mouse.
Click Change series chart type Target
I want a line oh that doesn't look right it's the wrong way around your Technique isn't working let me just draw it what no no okay okay.Um board shorts are tricky with the second series we just have like two minutes left time for a hack just move it okay here's what we're gonna do delete this chart.
Let's just move this to the side now I'm going to highlight the cells the chart is sitting on press Ctrl C go to the side here home paste and paste this as a linked picture so not picture but a.
Linked picture this way it's a live picture so let's just turn this around and now we are getting a bar chart but it's not the way it should look but no worries we're going to make the.
Adjustments here so first of all it should be a lot thinner right so that looks better we should bring the bars closer select them in our original chart press Ctrl 1.
For Gap width let's go with 40 now this is starting to look great but we want to turn these around so let's select the labels under alignment for text Direction Change it to rotate text to.
270. now this looks good we're also going to rotate this one I tend to click on this but we have to do it here select it let's go ahead and rotate it to 70. that looks good the same for the data.
Labels rotate to 270. we have our Dynamic bar chart created and check this out if Target changes to 200 this updates 320 it updates everything is dynamic but we have a bar chart with a.
Target line okay I'm late I gotta run just save this on the drive please what just happened I wish I could rewind that [Music].
