Copy and paste down and across as far as needed.Ĥ) In the chart, move the existing data series so it refers to column V. Note the mix of relative and absolute references to make copying easy. This step may not be necessary, but it will make that future IF() function a lot easier.Ģ) In V4 I enter "web site 1", in W4 I enter "web site 2", and so on for as many projects as you ever expect to have.ģ) In V5, I enter my IF() function =IF($A5=V$4,$E4,NA()). This will be important later when I set up the IF() function for each data series so that function will know which project goes with each row. In your sheet, I:ġ) Widen column A, unmerge the cells, rotate the text horizontal, then copy each "group name" into each cell (so copy A5 "web site 1" into A6 to A13, same for other projects). Note in the tutorial that most of the work is in the spreadsheet to setup each data series range. I would follow something like this ( ) where each "project"/"color" is added as its own data series.
0 kommentar(er)
