Microsoft Excel 2010 - Macros Writing Lesson 3 - How to generate Graphs using Macros

Please visit http://www.techflutter.com to download the code and see our other macros. We also provide a custom macro service, see our website for more details.

---

Closed Caption:

let's go folks today I'm
gaunt show you lessons free which is a
macro
had generate across and Microsoft Excel
so we have
seventh outta here this is Justin you
said it generator
we have find number name
find and matter talk feat that they have
paid
so some some people have paid a total
amount
or the paint and the percentage of so
what you want to do with the Stars
want to use and Microsoft Excel generate
a graph on monetary
say for example if we ever more about it
here
we would like to senator graph
so if we have the macro to do that we
can just a couple
and the graph be generated on our
someone who is another
work on the basis of the wealth here
and what you have to back to compile
them working then we cannot we cannot in
some more people
I'm again regenerate the process very
very useful
especially useful for am if you copy
organization
love it love that he wants or their do
something similar
and you can use this approach if you do
you have any questions will be more than
happy to help
you can follows on Twitter of text for
again socialist you need to do a video
and
tutorial if you have a specific request
that's no problem at all
okay so first things first I wanted my
phone to record myself so I want the
macro to record me
sort it out a so not assault other their
term the column C so high so lost and I
also want the bar
for me doing the graph and then what
hafta that basic all that we can weaken
in for our
have presented a cold okay so we're
gonna star
daredevil or or demographer so
or RT okay so
are gonna highlighted out I want so it
says a one
8:30 for his face
so remember future cases there may be
more gonna
second hour six or on
I'm going to solve volume and of 12 feet
eight so we go here
%uh on largest to smallest so we'll see
their lives on the left
people pay the smallest on the right are
click OK make sure your hardware by the
house headers as well
okay okay perfect
now we want to answer the are
so ago in sir haida on which to select
the basics
to be caught in traffic remote perfect
their craft
quite simple to them and we have all the
call in and say
in the back of our someone who knows I
don't to go interview
on macros on this topic or now I want to
see a.m.
coal generates on other type out %uh FL
notice that it to call Dave
finished so nice car so you what was
generated here
okay so this this is while
we just generators by doing what we did
the problem here is the heart of the
range rights
did because we select this epic rage is
a cop prevent
done sets here they are 5 rate so we
have able to see 13
see to to see turkey
set range and
a want to see thirty okay on the last
one here
is this one here daughter a
dont want secret so they were happy in
of
with the the a5 strong gonna have the
name on
on this starts over those it's easy to
use a week weekend he tells us there
for to see turkey that is
dependent on carry on how lives without
its cities
so we need to change that that can
change each time so what I've done here
to copy this code it not the end so
a copy of this a I'm not a cop it isn't
it
programs out there call that we for
about the last which was then
which was there macro
so it's pretty much the same cost us a
except for in the main loop
I have removed HBO called which was the
colder use not us that since you
checked that the primary colors other
replace it with this
okay that I thought so man
adjustments here so all it is.
I've used it hotter before
the told counter to counter to their
cells
I've also party Sacramento once
here so all we do is we RTN range
a warm Colin C there
idea up her son accounted for gives us
the whole string
a want to see Turkey in this case and
and talk and becoming more
we've also the same here ionesco for
talk laughter
on Sep range also them here
dispenser program is just so you can
adjust honey I'm gonna set you input
into this
I'm also on the same which is on
called to okay so a lot of packets in
Microsoft Excel file
I don't delete this has a lot to do two
rooms here
a safe okay so I know my grass car
sonar Omaha fucking I can s2s run amok
Rican
am you lack of care
or UK there run the macro by going into
the window like this
I'm clicking on the label so not a
literal this matter further
came across just run going here
at sea without us just perfect it's
basically
and solved all the data according to the
the no 12 PK
on it's also I am father doesn't want
in this format is for mister finds
officer fine this is perfect
okay so now I want to do and they want
to
on out some more and want to delete this
file
%uh having I have some new clients okay
so I've slots artist I like it
and other
sore okay I want to sort this out of 5
client number
so artists monster life
smallest I've okay so now let's say for
example
we need to generate you graph I'm we
have new clients
okay so we can %uh we cannot it's a new
clients we put in
for me 15 sick okay
we have a when you climb collender
body
here
and start okay you clients
there you can put some funny for an
someone here and and is paid
351 by the state 25
is a complete ban on a piece of paper 85
shown on state sixty
okay okay said I was a saber donde
on that's gone wrong on our program so
we want the update process
for for de som we want the macro the
camps
as fire song which is row and set dates
on
that let's remember love you I hope
macaws so slow chrome on Mac Pro Series
actually it is just a sample set we have
brought him again just to be done
no two seconds microphone or
here we are and new data
%um just make them
but there is so we can make fewer
0 we've all the new got here
on an Interpol UK I we've included all
that
you people there see you cannot as many
people as you want and I seventy
the higher for you just to finish
December
go off go back in time for them
I just remove wasn't too we acted only
was it to anymore
its service for kristys to take another
call upon retirement program
so it is right click last movement to
d 164 no we don't need subs techno
think safe on their server so this macro
will
generate a graph very easy for you see
you can set
and I'm tentative graph you want
just by going into and the insert
you can select any these graphs just
makes you recorder Co
and make sure you you if use of by
whatever you want to stop by so
through all the first and in your
template bring in the back row
I they just changed the last summer to
talk after okay
so thanks everyone for watching and you
can follow us on Twitter
are for chairs I just remember if you've
any a.m. specific
equation no problem gets worse in some
way have a look at those making dessert
videos for you