Hi,
Does anybody have experience of creating graphs in Access?
I have a table which I want to be able to put on a graph in a report, but access doesn't seem to let me graph more than 6 fields at a time.
The table has a 'Products' field with around 100 different products. It then has 12 different month fields (I'e Jan Total Members,Feb Total Members, Mar....and so on) with a new month constantly being added. I want to be able to show graphically the change in members from month to month for each product. The idea being that if a particular product is selected via a form then the report would show the graph for
the product selected. I also want to be able to show a graph by the supplier, which is also a field in the table-there are around 30 different suppliers and 100 products.
Does this make sense, can anybody help??
Does anybody have experience of creating graphs in Access?
I have a table which I want to be able to put on a graph in a report, but access doesn't seem to let me graph more than 6 fields at a time.
The table has a 'Products' field with around 100 different products. It then has 12 different month fields (I'e Jan Total Members,Feb Total Members, Mar....and so on) with a new month constantly being added. I want to be able to show graphically the change in members from month to month for each product. The idea being that if a particular product is selected via a form then the report would show the graph for
the product selected. I also want to be able to show a graph by the supplier, which is also a field in the table-there are around 30 different suppliers and 100 products.
Does this make sense, can anybody help??
