I have a spreadsheet with 3 tabs - Hiring, Staff, and Metric. Sample uploaded.
- The Hiring tab includes a list of all jobs that are or have been hired with fill date and person who got the job.
- Staff tab includes list of all staff in the organization.
- Metric tab - here I would like to...
Hi All
I am trying to get count of Resources Type (Capital or Operating) if row is within certain month as specified in the Metrics tab.
The uploaded sample includes 2 tabs - Resources and Metrics. Resources is a list of Person records and whether they are Capital or Operating. Each row has...
Hi All
I am trying to build a line chart that shows me cumulative total of planned vs actual servers over time. Attached sample spreadsheet shows rows of server names each with planned date and actual date. I would like to show for year/month the number of servers planned and actual...
This is what I am looking for. The actual should count dates that are in the same month as planned date. For example, there are 15 servers with planned date in February and 12 actual dates in Feb. Is possible to show bar chart for Feb as 15 plan and 12 actual?
Hi All
I have a large number of rows of data each with server name, planned date and actual date. I would like to generate a stacked bar chart that shows total number of servers planned vs actual per month. Any guidances or samples?
Thanks.
Hi All
I have a spreadsheet that tracks thousands of operational metrics per month. I'd like to add conditional formatting, Red/Yellow/Green, based on threshold values for each metric. Due to the large number of metrics I want to avoid manually setting Conditional Formatting for each row and...
Hmm! When I use your method in Excel 2011 for Mac it works great; however it does not work on Excel 2013 (Standard) on Windows 8! The formula generated #VALUE! on array references $A$2:$A$19, $C$2:$C$19, and $D$2:$D$19.
I have a rate table showing various job roles. There are two types of rates for each job role - Employee rate and Contractor rate. I'd like to present a bar chart that shows Employee and Contractor Average rate with minimum and maximum rate as error bar. The chart will be filtered by job...
I have a table with multiple columns and each column has Named range. In a formula, I would add [@RangeNameColA]. When I copy-paste the formula to other locations (say to next set of cells horizontally), the reference changes to [@RangeNameColB], [@RangeNameColC], etc. I'd like to make this...
I have two worksheets: ResourceDemand that lists all the projects and estimated resource needs by fiscal quarters, and PojectCapacity that lists all the resources available with their start and end fiscal quarters. Resource available could be either fulltime employees or term based contractors...
I have tried this approach and though it does work, it then prevents any manual addition of series. I'd like to be able to add series manual as well due to some data being overlaid from other datasheets.
I have a pivot table with 70+ columns, each with named range. I'd like to add each of the column as a series to a chart. What's the quickest way (instead of manually adding one at a time)?
I was able to get @Nebu's workaround work off Capacity worksheet for a single Role. If I select multiple role then the formula does not sum up the number of Roles. Still looking to reflect Capacity on the chart so that when slicers filters (one or many) are selected it also works on Capacity.
@Nebu, thanks for the workaround. I will try this out. You've calculated the Capacity based on ResourceNeeds worksheets whereas the Capacity is provided in the Capacity worksheet. It is this Capacity worksheet data I need to overlay on the chart.
Hello
Uploaded is a sample file with couple of worksheets (different formats) that needs to be presented in a Chart with Slicers.
1. ResourceNeeds worksheet provides a list of all projects, phases, resource roles, and estimates of resource role required by financial quarters (Q1, Q2, ...)...