I been googling and youtubing forever now feels like and I`d be really happy if anyone could help a newbie + user to make the right choices.
First, some info regarding what I got:
My sheet contains 10 sheets of data, a data sheet with formulas & connections and a dashboard sheet where I`d like to visualize the 10 sheets nicely, simple but informative. The reason why I have 10 sheets is due to every sheet holds a list of tag ids from different groups of valves i.e manual valves, Choke valves and so on.
Every sheet can hold from 4 tags and upto 137 to the most. Therefor it makes it difficult to show a status for every tag id, but I guess im just thinking wrong since I know Excel is super smart and hope there is help in this super smart forum :D
So, some more info regarding the info I want to visualize:
Every tag ID in the different group(sheet) has 3 columns showing status with 4-5 different actions in a drop down menu function. I made an value column for each column to get a numeric value for the chosen action since pivot table only uses numeric values.
And now, this is what its in my mind how Id like to visualize it all:
1. 3 bar graph`s showing the overall status for all the groups. In detail; the 1st bar graph with 10 columns for every valve group to show the status of lets call it inspection. The next bar graph to visualize the status of action from the inspection and the last to show the activity of the action.
2. I want also to make a line graph for all the valve groups to visualize the start date/status of the activity to see the overall progress of all the tag id`s from the groups.
3. Last, I think, I guess I need several pie graphs(or other) to visualize every group by it self with the 3 different status columns in %.
So, please. Can anyone help me with some tip and tricks here. I do know to make a pivot table for multiple sheets, I do know how to make all the charts, but I guess I dont know how to sort the values correctly in the Fiel list since it gets cludded with too much info when its sorted on tag IDs. I did try different options not sorting on the tag IDs but then it werent possible to refresh the data and the sliders didnt make it interactive..
Bookmarks