Trying to find the best way to display some metrics and am coming up with a blank as I need to provide business metrics data for number of calls data and preferably with Excel 2010.
Initial thought was to create a line graph with points and hyperlink the points to the sub-topics but can't figure out how to do that, then I thought about a bar graph with different layers to it as to each sub-topic with no such luck.
Example below:
Specific Administration is the overall topic with a total of 417 for all other categories with "Add/Edit Contacts, Policy, Proctor Password, Request to Change Data" all falling under Specific Administration.
Then Navigation falls under Add/Edit Contacts, and General, Refer to XYZ, Refer to XY all falling under Policy and of the 381 stats for Policy is broken down by those and so I need to put that information with the sub-topic but not all sub-topics will have a sub-topic layer 2
Main topic Specific Administration-417: Sub-topic Add/Edit Contacts-5 Sub-topic layer 2 Navigation-1 Sub-topic Policy-381 Sub-topic layer 2 General-160 Sub-topic layer 2 Refer to XYZ-61 Sub-topic layer 2 Refer to XY-160 Sub-topic Proctor Password-5 Sub-topic Request to Change Date-26
Bookmarks