Thread: Help needed to create bar chart from 3 columns

I have 3 columns of data that I'm trying to create an excel chart for. I'd like to see a the Count field on the Y-Axis and the Audit Date on the X-Axis with Station Number being what is graphed in different colors. I haven't found a decent way to map this to a chart. It seems to be set up mostly for 2 column data, from what I've seen (but what I don't know about Excel Charts could fill a warehouse). Also, my dates get mapped as a number instead of a date. Does anybody have suggestions on how to do this?

Thank You.

sample data
Count, AuditDate, Station Number
1 29-Oct-09 549
5 30-Oct-09 100
1 30-Oct-09 122
3 30-Oct-09 191
1 30-Oct-09 464
2 30-Oct-09 532
1 30-Oct-09 775
2 30-Oct-09 852
1 30-Oct-09 981
4 31-Oct-09 152
1 31-Oct-09 171
1 31-Oct-09 320
1 31-Oct-09 606
1 31-Oct-09 701
2 02-Nov-09 122
1 02-Nov-09 152
1 02-Nov-09 532
1 02-Nov-09 775
1 02-Nov-09 852
1 02-Nov-09 981

Andy,

Thank you very much. This is what I needed.

One additional question. How would I get the Station Numbers to graph as individual bars (per date), instead of being stacked on top of each other?

Thank You.