Macro help (VB)

[Ian Betteridge]

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

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

 

[Krishnakumar]

Hi,

See here something similar to yours.

 

[Ian Betteridge]

Thanks Krishnakumar,
This could be very useful.