Hi is it possible to do a stacked chart for the following table? I want to show the names/% as stacked column against each Location (x axis). The original formula is in a table with many zeros so I copied and pasted to another table. I want to show the % of sales by each salesperson at all the locations but there are 50 sales people and locations and only 3-5 people in each location. If i do a chart with all that data most of it will be zero or blank so i thought this would be easier.
Really appreciate any help.
Thanks
Really appreciate any help.
Thanks
Location 1 | Adam17% | Richard47% | Stefani8% |
Location 2 | Venkata100% | ||
Location 3 | Rosaria100% | ||
Location 4 | Lisa18% | Jacky82% |