I don't know where to start, but the final product I'm looking for will be a stacked chart, so I'm asking here.
I have an excel file that holds event data. I want to be able to see an entire season's days (as one axis), and how many events are being held on each day (as the other axis) by type of event or as a total. A season is anywhere from 3 to 6 months. I will need to see it by vendor, or by event type or both.
I have attached a tiny example of the data I am to work with. Where do I start? I've built this chart in Excel, but it takes hours. I'm mediocre in Access, but linking a query and a chart macro to a table will be far easier than re-creating this chart whenever I need it.
I know I've left a lot of info out, but any help anyone can provide would be fabulous! I've attached a tiny example of my spreadsheet to this.
I have an excel file that holds event data. I want to be able to see an entire season's days (as one axis), and how many events are being held on each day (as the other axis) by type of event or as a total. A season is anywhere from 3 to 6 months. I will need to see it by vendor, or by event type or both.
I have attached a tiny example of the data I am to work with. Where do I start? I've built this chart in Excel, but it takes hours. I'm mediocre in Access, but linking a query and a chart macro to a table will be far easier than re-creating this chart whenever I need it.
I know I've left a lot of info out, but any help anyone can provide would be fabulous! I've attached a tiny example of my spreadsheet to this.
