I am working with CR XI and Access 2007.
I have two dates I want to combine into one graph and one date group.
Fields: [registered date],[sold date],[registered revenue],[sold revenue] all in one record.
I want a graph to graph this as one graph by week:
Week Beginning [registered revenue] [sold revenue]
02/18/07 1000000 200000
2/11/07 1250000 350000
Is this possible or do I have to create two separate graphs and overlay one on top, which I tried and it is not simple.
I have two dates I want to combine into one graph and one date group.
Fields: [registered date],[sold date],[registered revenue],[sold revenue] all in one record.
I want a graph to graph this as one graph by week:
Week Beginning [registered revenue] [sold revenue]
02/18/07 1000000 200000
2/11/07 1250000 350000
Is this possible or do I have to create two separate graphs and overlay one on top, which I tried and it is not simple.