I have a table organized as follows (simplified)
A B C D E F G H I J 1 Week # M T W Th F S Su Totals 2 1 10 3 500 4 2 15 5 400 6 3 23 7 350
Every row of every week represents a value and I would like to chart them as series. In other words, my 2 data series (in the example) are: (J2,J4,J6) and (J3,J5,J7) with y-values of (10,15,23) and (500,400,350).
How can I enter the correct references for a series of disjoint cells in the chart wizard? It only seems to accept contiguous areas with the area selection button. Or do I have to manually type the lists? The real ones contain several dozen cells each…