Forum Discussion
Help creating a chart
Hi all, I am seeking help on how to create a chart that shows employees that have worked in more than one agency. I think that the best way to represent it is by the number of links. I have an Excel ...
Anonymous
Load your file to somewhere like Google Drive, OneDrive or Dropbox, then link to it from here.
Phil
Here is the link to the file on DropBox https://www.dropbox.com/scl/fi/9xt2gft4yggii4wk8m8x1/Transits-Across-EU-Agencies.xlsx?rlkey=fog1l2uopynglses69dvjldqf&dl=0
Anonymous
in PQ， select the agencies column and unpivot other columns.
then it will be easy to get the result
Thank you but this puts the focus on the agencies. I would like to show how people have traveled across agencies. Thus, some kind of bubbles with links if at all possible, would represent this.
what's the expected output? could you pls create the output in excel and paste the screenshot?
