in the column next to that, type in this formula: in one column, list all the possible departments you might work in.ģ.

Any ideas? posted by WCityMike to Computers & Internet (9 answers total) 3 users marked this as a favoriteīest answer: Here's how I would do it (caveat: no doubt there's a way to do this 10 times faster/easier):Ģ. Is what I'm talking about possible? I thought it'd be something that Excel could do with its eyes closed, but not only did I dredge up a big fat zero when trying to figure this out, so did my business' help desk. Keep in mind that since the number of entries in that column will change on a daily basis, I'd prefer not to 'hardcore' into any existing formula or chart or what-have-you the rows part of the range, unless it can't be done otherwise. based on its own, updated count of the frequency of appearance of the departments as compared against the total non-blank entries in the column in question.Īnd if all the following week, I worked for the BallmerAssassin department, it would automatically add in the appropriate slice and udpate the chart. I'm looking to figure out how I can get Excel to create a pie chart that would have 40% widget-making, 20% rotor-scooting, 20% GatesAssassin, 10% Metafilter-Reading, and 10% RealityDistortionField-Creating. Let's say, for example, that the department column of this spreadsheet looks like this: The latter is not entirely necessary if it would add too much of a complicating factor. I'm seeking to figure out how I can have Excel create, and automatically update, a pie chart based on the 'department' column, and, optionally, to help me break down further in some clickable way the practice area off of the respective departments. The horizontal subject headers are 'date,' 'secretary,' 'department,' 'practice area' (a sort of 'subdepartment'), 'attorney 1', 'attorney 2', 'attorney 3', 'attorney 4', and 'notes.' The vertical headers are the dates I work. I keep an assignment log as an Excel spreadsheet, detailing where I worked each day, and any personal notes about the desk. I am a legal assistant whose station changes from day to day and week to week (a 'floater').

How to make a pie chart in excel m