LeeStallan
New Member
- Joined
- Jan 18, 2014
- Messages
- 28
Hi all,
I know this question has been asked over and over again, but no matter how much I search I dont seem to able to find a suitable resolution.
My challenge would seem to be simple, but I am unable to sort it out by myself.
I work in a call centre and I record my daily figures. My target is 82%, and I would like a bar chart in Excel 2003 to colour the chart according to wether I hit target or not. If my daily figure >=82% the bar should be green. If daily figure <82% bar should be red.
I'm looking to use VBA to achieve this as I have a lot of data recorded on spreadsheet already, and dont want to use the 'multiple range extended table'. Ideally I would like to add the code to the Autpen macro which I have.
Any help or pointers will be GREATLY appreciated
Thanks
Lee
I know this question has been asked over and over again, but no matter how much I search I dont seem to able to find a suitable resolution.
My challenge would seem to be simple, but I am unable to sort it out by myself.
I work in a call centre and I record my daily figures. My target is 82%, and I would like a bar chart in Excel 2003 to colour the chart according to wether I hit target or not. If my daily figure >=82% the bar should be green. If daily figure <82% bar should be red.
I'm looking to use VBA to achieve this as I have a lot of data recorded on spreadsheet already, and dont want to use the 'multiple range extended table'. Ideally I would like to add the code to the Autpen macro which I have.
Any help or pointers will be GREATLY appreciated
Thanks
Lee