Hi, i'm pretty new to this but here goes .
I have a scoring table as such, with two main outputs ( importance and urgency , computed in the last two rows )
iu-score.jpg
which i will plot into an x-y scatter plot based on the last two rows ( urgency on the x axis and importance on the y axis) as shown below
scatter.jpg
However, each data point is manually entered to represent its project number ( insert shape with respective project number, fill picture into data point ) .
is there any way i can allow for
1) the table to expand accordingly as projects increase
2) the customized data point to be automatically added ( circle, random color, with project number in the circle )
Bookmarks