macro to change chart on excel data field

  • Thread starter Thread starter b_b_a_e_c_h_t
  • Start date Start date
B

b_b_a_e_c_h_t

Hi all,
I'm wanting to create an Excel ( Excel 2000 ) macro that will read
through a sheet with column data in it. I've created macro's to graph data
in the past but I'm having a hard time figuring out how to change graphs on
change in a field of the data. I.E.

class date docs pages
acctg 5/1/2004 1 5
acctg 5/2/2004 3 18
payable 5/1/2004 5 25
payable 5/2/2004 8 24
....

My goal is to create a chart for each change in class as detailed above via
a
macro. Any ideas???
 
I would step down the first column, keeping track of the label in the
cell. When I first encountered a different label (acctg <> class) I
would start a new range with the first cell that says acctg. If the next
row also says acctg, I would extend the range by a row. I would stop
extending when I found a different label. Whenever I stop, I would then
define the date, docs, and pages ranges as offsets from the class range.
I'd make my chart, assign the ranges to the values or categories of the
chart. Then I'd start with the next range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
I would step down the first column, keeping track of the label in the
cell. When I first encountered a different label (acctg <> class) I
would start a new range with the first cell that says acctg. If the
next row also says acctg, I would extend the range by a row. I would
stop extending when I found a different label. Whenever I stop, I
would then define the date, docs, and pages ranges as offsets from the
class range. I'd make my chart, assign the ranges to the values or
categories of the chart. Then I'd start with the next range.

- Jon
Click to expand...

Hi Jon,
That sounds amazingly simple. Thanks for the advice. I'll get after
it. It sounds pretty dang easy as well so hopefully I'll have it done
soon. Thanks again!

Bryant
 
(e-mail address removed) wrote in
Hi Jon,
That sounds amazingly simple. Thanks for the advice. I'll get
after
it. It sounds pretty dang easy as well so hopefully I'll have it done
soon. Thanks again!

Bryant
Click to expand...

Thanks for the direction on the macro. It works great!

Bryant
 
Back
Top