Author Topic: Visualizing data in excel  (Read 4311 times)

0 Members and 1 Guest are viewing this topic.

xantius

  • Newbie
  • *
  • Posts: 2
Visualizing data in excel
« on: February 14, 2011, 05:12:33 PM »
I'm trying to create a table in Excel, and then  have shapes created that include each line of data sorted by department, and then have all line items that match up under that department underneath it. Even better would be the ability to have a color changing icon next to each line item to show how close we are to completing each project. Example:
Excel table
DepartmentProject
SalesCreate new logo
HRProject 1
SalesProspect
HRProject 2


Sales
  • Create new logo
  • Prospect

HR
  • Project 1
  • Project 2

I want to dynamically lay out these projects by department (and possibly other ways, but display them visually). What do you recommend?


xantius

  • Newbie
  • *
  • Posts: 2
Re: Visualizing data in excel
« Reply #2 on: February 14, 2011, 11:20:40 PM »
Thanks for the links. I think that PivotDiagrams are what I'm needing to use, but what I don't get is how to lay out the line items under each department in a way that packs them close together. RIght now the default is to create each line with it's own large box. These boxes then flow off the page. How would I change the formatting do display this almost like a table with each line item being a cell that is flush up against the other?

aledlund

  • Hero Member
  • *****
  • Posts: 1412
Re: Visualizing data in excel
« Reply #3 on: February 15, 2011, 09:13:36 AM »
you should probably start over here

http://www.homeandlearn.co.uk/me/mes9p4.html

to better understand the excel materials first

al