Hi, I have spreadsheet which contains multiple users’ name with balance date and balance.
Example data is:
User | Date | Balance
user1 | date1 | 100
user1 | date2 | 200
user1 | date3 | 300
user2 | date4 | -10
user2 | date5 | -20
I want automatically generate XY chart where date is X-axis and balance is Y-axis, next to each user’s data. I can manually create XY chart for each user, but I have many users, so i want to automate it.
I’d appreciate any help or input you guys have to offer.