Ian Betteridge
Active Member
- Joined
- Mar 25, 2006
- Messages
- 472
Hi All,
I've got a worksheet that I want to extract certain data to build a chart. In column A lists the area of work (10 different areas). Using a macro I want to be able create a chart in another worksheet (Chart1). The macro button I want to place on the Chart1 worksheet so I can hide the source data. By creating ten buttons each time a macro each selected a different chart is displayed worksheet Chart1. I can achieve my aim by using a filter on column A but the sheet is used by many and wish it to be simpler for end user by creating the macro. I've enclosed a brief list below but as I've already stated the sheet is actually 176 rows, so all can't be displayed.
Hope someone can help..
Many Thanks
Ian
I've got a worksheet that I want to extract certain data to build a chart. In column A lists the area of work (10 different areas). Using a macro I want to be able create a chart in another worksheet (Chart1). The macro button I want to place on the Chart1 worksheet so I can hide the source data. By creating ten buttons each time a macro each selected a different chart is displayed worksheet Chart1. I can achieve my aim by using a filter on column A but the sheet is used by many and wish it to be simpler for end user by creating the macro. I've enclosed a brief list below but as I've already stated the sheet is actually 176 rows, so all can't be displayed.
Hope someone can help..
Many Thanks
Ian
Hrs Booked CCarr.XLT | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | PM01 | PM02 | PM03 | PM04 | Total Hrs. | |||||
2 | Tech ops J | 5210019 | B McCambridge | 0 | 0 | 0 | 0 | 0 | ||
3 | Tech ops F/C | 5210031 | M Heginbottom | 0 | 0 | 0 | 0 | 0 | ||
4 | Alfs Logistics | 5210039 | D Baker | 0 | 0 | 0 | 0 | 0 | ||
5 | Tech ops F/C | 5210065 | D Bentley | 0 | 0 | 0 | 0 | 0 | ||
6 | Tech ops E | 5210088 | S Greaves | 0 | 0 | 0 | 0 | 0 | ||
7 | Tech ops E | 5210251 | G Hitchen | 0 | 0 | 0 | 0 | 0 | ||
8 | Tech ops H | 5210316 | R Maughan | 0 | 0 | 0 | 0 | 0 | ||
9 | Tech ops J | 5210442 | S Hayes | 0 | 0 | 0 | 0 | 0 | ||
10 | Tech ops J | 5211639 | P Howard | 0 | 0 | 0 | 0 | 0 | ||
11 | Tech ops J | 5211671 | D Frazer | 0 | 0 | 0 | 0 | 0 | ||
Table |