New to reports coding - vba help

  • Thread starter Thread starter Amanda
  • Start date Start date
A

Amanda

Hello,

Basically: I have weather data broken up by region, state and month

I want to make a grouped report in the following hierarchy/grouping

Region
-State (on the "Y axis")
-month on the "x axis")

And then weather filling inside

As in



New england

Aug Sep
NY. 10. 15
MA. 20. 30

Basically this demonstrates my end goal. I can perform this analog
(clicking etc) but I want to automate this.

Any help would be great!
 
Let me qualify:

Each time I will be deleting and recreating the report. I am aware of
the shell getting filled each time by a different sql statement and
how to code that.

I basically want to create a fresh report each time.

Thanks!!
 
There is a discussion group for 'Excel Charts'. You can try that; may be
more appropriate. Or send me an email, with details about what you want, and
I'll try to do this for you.

(e-mail address removed)
Remove the xxx (bots go through these things and scan fro email address).

Ryan---
 
Back
Top