atokatopia
New Member
- Joined
- Jun 28, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello! I have a pivot chart for the top revenue company by week. Is there a way to combine the four lines together into one and automatically change the line color by company (A, B, C, D)? I would love to automate this as the number of companies will change. Thanks in advance!