I have this data, with the frequency of specific categories and the years they occur in.
A B C D E F G H I 1272 58.2 25.4 6.1 3.0 2.0 4.1 0.0 0.0 1.0 1312 51.0 18.7 8.7 4.7 5.4 4.0 2.7 2.0 2.7 1360 33.6 35.0 11.2 6.3 9.1 2.1 0.7 1.4 0.7 1379 40.0 26.7 20.0 0.0 0.0 0.0 6.7 6.7 0.0 1381 41.9 33.6 10.5 4.3 5.5 1.6 0.6 0.6 1.1
I want to create a XY scatter plot with trendlines, with years along the X axis and frequency along the Y axis. Each category wants to have its own individual trendline. However, I specifcally want to exclude 1379 from the trendlines it draws. Instead, I want 1379 to be graphed effectively as a secondary scatter plot without lines, so that I can see if my data for 1379 is consistent with data for the other years.
I've attempted to set 1379 as a seperate series but that doesn't work as the series are the categories of A-I. The only solution I can think of is to create two seperate graphs and stack them on top of each other and adjust the transparancy, although this is obviously not an ideal solution as it won't be 100% accurate.
Any help would be appreciated.
Bookmarks