Updatable chart?

  • Thread starter Thread starter HoundofCullin
  • Start date Start date
H

HoundofCullin

Good Afternoon my helpful amigos.
I have yet another query for you.
I am working at building a line graph chart to compare day to day
temperatures of various devices. What I would like to know is if there
is a way to update the chart on a day to day basis or if I'll have to
re-write the chart with each update.


For example:

Let's say I'm makin a line graph to compare temperatures for this week,
so we've got this data.

Mon, 105 degrees
Tue, 107
Wed, 104

Now, to that line graph I'd like to add Thur, 108degrees.
Is there a way I can just enter the extra information or do I have to
make a new chart with:

Mon, 105 degrees
Tue, 107
Wed, 104
Thur, 108

By jove I hope that made sense.
 
Place the following Macro in the same module and call whenever you have
added an extra line of data


Code:
--------------------

Sub UpdateGraph()
Sheets("Chart1").Delete
Call Graph
End Sub

--------------------
 
Indeed it does help! What a pal!!!

Not only did it give me a base chart to work from... it makes the world
of... uh... Chartdom much simpler to comprehend.


Thanks a ton,
Josh
 
Back
Top