Hr is the hour, Cd is the code and Num is the count of Cd.
I wish to create a table that will display the Hour on the x-axis and the count on the y-axis. There would be a seperate bar for each code. Therefore in most cases there would be 3 bars [on for each code] for every hour.
How can I acheive this? I tried using the chart function in excel but I cant seem to get it display the data the way I want it.
I have quite alot of data so changing any of is manually is a no no.
I would do this with a pivotchart which you can do if you have excel 2000 or higher
that way when you create your table you can mess about with the chart to get it how you want it
what you probably want is your data organised into a table rather than a list, which a pivottable will do easily for you,