• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. C

    conditional count based on lookups

    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...
  2. C

    Count with multiple column criteria and within date range

    I tried PivotTable but am unable to determine date condition.
  3. C

    Count with multiple column criteria and within date range

    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...
  4. C

    user form to input data in different columns

    How is this done?
  5. C

    Cumulative Line Chart Over Time Period

    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...
  6. C

    Bar chart showing planned vs actual volume per month

    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?
  7. C

    Bar chart showing planned vs actual volume per month

    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.
  8. C

    Automating conditional formatting

    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...
  9. C

    Error Bar chart showing min, max and average of two series

    I figured it out. The whole formula expression was missing {...} squiggly brackets.
  10. C

    Error Bar chart showing min, max and average of two series

    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.
  11. C

    Error Bar chart showing min, max and average of two series

    Thanks, Somendra. This will work. I will need to adjust the filter to allow user to select all or many values.
  12. C

    Error Bar chart showing min, max and average of two series

    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...
  13. C

    SPEEDOMETER OUT OF THE DRAWING

    i am very interested in this. How is the graphics made to react based on values?
  14. C

    Absolute named reference?

    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...
  15. C

    Need advice to create step line series on two different pivot tables

    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...
  16. C

    Quickest way to add large number of series to a chart

    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.
  17. C

    Quickest way to add large number of series to a chart

    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)?
  18. C

    Adding a new series to a PivotChart from another PivotTable

    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.
  19. C

    Adding a new series to a PivotChart from another PivotTable

    @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.
  20. C

    Adding a new series to a PivotChart from another PivotTable

    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, ...)...
Back
Top