huntmeister007
New Member
- Joined
- Feb 11, 2013
- Messages
- 1
Hello,
I'm having some trouble making a dynamically updating chart in excel 2003. I'm fairly new to excel, but my boss wants me to make a graph that will update every week as we recieve more info into a certain file. Basically it's the alcohol drinking habits of the southern states, broken apart by state (columns) and type of drink (rows). The new data is added in columns to the right every week, so I have the oldest data in columns J to P, the following week in Z to AF, the week after in AP to AV, and so on. I want my graph to have two drop downs- one that will select the state, and one that will select the type of booze, so I can look at the data as granularly as I would like. I have no experience with VBA and would like to do this as easy as possible- but I'm sure this will be a hassle. Can anyone help/direct me to help??
Thanks so much to anyone who can help!!!
I'm having some trouble making a dynamically updating chart in excel 2003. I'm fairly new to excel, but my boss wants me to make a graph that will update every week as we recieve more info into a certain file. Basically it's the alcohol drinking habits of the southern states, broken apart by state (columns) and type of drink (rows). The new data is added in columns to the right every week, so I have the oldest data in columns J to P, the following week in Z to AF, the week after in AP to AV, and so on. I want my graph to have two drop downs- one that will select the state, and one that will select the type of booze, so I can look at the data as granularly as I would like. I have no experience with VBA and would like to do this as easy as possible- but I'm sure this will be a hassle. Can anyone help/direct me to help??
Thanks so much to anyone who can help!!!
