Hi
I have a pivot table from SAP with following:
Description of functional location in rows, count of notifications and sum of total cost in values.
I would like to make a scatter chart with the notifications on x-axis, cost on y-axis and the description in the legend (referring to a color of a point). And then I can divide it in 4 areas(high cost/high notification; low cost/high notification;...)
I managed to make one (not with the pivot tho) by selecting the description as series name, and then x and y for cost and notification. However, I must do every single row separately. Is there a way to just select the entire columns? I have over 350 rows so doing everything separately is impossible.
Kind regards
Bookmarks