Here is a hard one (I think!) to challenge someone.
I have a table of quantity of ppl by half hour of a day as in:
11:00 3
11:30 5
12:00 4
12:30 6
and so on.....
and need to show it pictorally (not as a graph!) as follows:
11:00..11....11....11
11:30..11.5..11.5..11.5..11.5..11.5
12:00..12....12....12....12
12:30..12.5..12.5..12.5..12.5..12.5..12.5
and so on.......
This does make it look like a bar graph I know.
This part I have managed to do with IF statements and some VBA, it is the next stage that at the moment users are having to do manually and it would be alot quicker and easier if I could find a way to automate the last step or even miss out the above step and go straight to the last below
11:00..11....11....11
11.30..11.5..11.5..11.5..11.5..11.5
12.00........12....12....12....12
12.30........12.5..12.5..12.5..12.5..12.5..12.5
and so on......
Im not sure how the above will look on this message or if I have made any sense so if you can't understand it and you think you might be able to help I can e-mail an example to you.
Thanks in advance
Dan.
I have a table of quantity of ppl by half hour of a day as in:
11:00 3
11:30 5
12:00 4
12:30 6
and so on.....
and need to show it pictorally (not as a graph!) as follows:
11:00..11....11....11
11:30..11.5..11.5..11.5..11.5..11.5
12:00..12....12....12....12
12:30..12.5..12.5..12.5..12.5..12.5..12.5
and so on.......
This does make it look like a bar graph I know.
This part I have managed to do with IF statements and some VBA, it is the next stage that at the moment users are having to do manually and it would be alot quicker and easier if I could find a way to automate the last step or even miss out the above step and go straight to the last below
11:00..11....11....11
11.30..11.5..11.5..11.5..11.5..11.5
12.00........12....12....12....12
12.30........12.5..12.5..12.5..12.5..12.5..12.5
and so on......
Im not sure how the above will look on this message or if I have made any sense so if you can't understand it and you think you might be able to help I can e-mail an example to you.
Thanks in advance
Dan.