in this video I'm going to show you how to grab changing data in Excel I had the
question the other day from someone who's saying that he's trying to graph
data that's changing all the time in Excel now it depends how your data is
changing in this first example I have the sales for a product for January and
we have the product and the sales for each item here and so how I am going to
put a graph on here is I'm going to select my data and I'm gonna go alt f1
which is the shortcut to put your standard-issue chart up here and so
there you're there it's perfect now February comes along and you would like
to also include the February figures in this graph so what I'm gonna do is I'm
going to enter the figures for February which I already have here now I'm gonna
go back to my sheet and I'm gonna put them in here but I'm also going to win
what they're still selecting it I'm going to select the chart and I'm gonna
go control V again right on the chart and they're your data is is plotted
again in here you can of course add legend on here too so you can
differentiate between January and February but same thing goes for marks
you could do the same thing for April and you could keep going this way and
each month when you paste it right on the chart it will include the chart that
you are doing so the other method would be things that are changing daily now
we're having a bit of a cold snap here and so these are the temperatures that
are forecast for this week so the trick to doing this is you create a table you
create a table you dad and will always be reflected in
your chart so I'm selecting my my data
this one I'm selecting my data and I'm going ctrl T to create a table and then
it's giving you the dialog box and it's saying I'm gonna create a table these
cells and you're saying that's fine and my date my data has my table has had and
say okay so now you have a table and so now I'm going to go insert and I'm gonna
go I want a line chart for this one so here's my line chart I've created for
these first three days now I would like to to plot the rest of the week here so
what I'm going to do is I'm going to drag down Tuesday to Saturday and now
I'll go back to my the website that I'm getting them then the temperature is
from and so Wednesdays - 32 Thursday's - 31 and Fridays and then Saturday we have
big warm up - 25 well so 32, 31, 30, 25 so let's go back and we'll go negative 31
and I think it's negative 31 the next day and Saturdays - 25
so as you're adding the data you notice that the graph changes along with the
day - being added so that's the advantage of for changing data that's
changing all the time when you can do is put it in a table and it will always be
reflected in your graph the other thing now that I'm addressing is another
question that I had so if you want to use this graph on another piece of
software you can of course select it and copy it and paste it to to Word or
PowerPoint or word wherever you want to do it but if you have some some other
either software that you would like to use this data and you can you can select
it and ctrl ctrl C to copy it and then you can bring up paint which is
available the one that comes standard with your Windows software and then you
just go control V it on the window and then you can crop it and then then
you're able to save it as you can save it as a PNG you can save it as a jpg you
can save it as a GIF or any other format that you want so there's no it's not
required that you take a screen print you can keep all the keep the resolution
that's available to you from the chart that you created in Excel so these are a
couple tricks using with Excel for continual data please subscribe