Hello,
I am trying to create an access graph in a Form.
The objective is to have a line-graph as a time series as shown below.
The issue I am having is that the data for facts is summed by the graph but I just want each value for each date to be a discreet point on the graph. Basically, I'd like a series line graph with dates at the bottom, the series = Industry names and data (or facts) to be the percent strength for that date.
What the line-graph should look like.
%
.05...x....z....z....y....y....x....z....z
.04...y....x....y....z....x....y....x....z
.03...z....y....x....x....z....z....y....x
.02.........z....y....y....x...............
......3/1.3/5.3/7.3/9.3/10.3/11.3/12.3/13
Legend
x = Information Technology (Industry)
y = Utilities (Industry)
z = Health Care (Industry)
Current data
Date....Industry.....................PctStrngth
3/1.....Information Technology......5%
3/1.....Utilities............................4%
3/1.....Health Care.......................3%
3/5.....Information Technology........4%
3/5.....Utilities.............................3%
3/5.....Health Care.......................5%
3/7.....Information Technology........3%
3/7.....Utilities.............................2%
3/7.....Health Care........................5%
ETC.
What I think the data needs to look like or perhaps Access can't do this.
........Information Technology.....Utilities.....Health Care
3/1................5%......................4%....... .....3%
3/5................4%......................3%....... .....5%
3/7................3%......................2%....... .....5%
ETC
Thank you. Hopefully, Access can create such a graph.