• 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. P

    Using Countifs to extract a year from an Excel Table

    I have data listed in a Table (meaning the excel function "table", not just cells) and I'm trying to create a summary table from that data. I'd prefer to use formulas for this rather than a pivot table. I'm having a problem with the formula. One of the countif criteria that I need is the year...
  2. P

    Show gaps in Excel 2016 charts

    I've just made the switch to Excel 2016 and am having trouble getting a graph to show gaps as it would have in 2010 (and previous versions). The chart shows multiple weeks of data including future weeks which will not be populated until those weeks pass. In previous versions, I would include...
  3. P

    Speedometer with multiple needles

    I'm trying to create a speedometer chart using Doughnut and Pie charts. I've got a doughnut that shows red, yellow and green performance ranges. I'm able to use a pie chart to show a needle indicating performance. I need to show 3 needles: beginning, previous period, and current performance...
  4. P

    Clear names from shapes (lines)

    I'm using some vba code to change the color of lines that make up a drawing. The color changes represent the completion of work on a project that the lines map out. I made the mistake of copy and pasting the first line segment to make up the rest of the lines. I had named that first segment...
  5. P

    Macro to safe worksheet as PDF

    I'm trying to save a file as a pdf using a file name and folder location that is dependent on variables in the worksheet. Here's the macro: 'Assign variable name for the file name FN = Sheet6.Range("N10").Value 'Save to PDF ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=FN...
  6. P

    Excel 2010 Column graph formatting (text v date axis)

    I'm creating a work book with multiple data tables and graphs that will be used over at least a year. I would like to select all available dates in the data table and then adjust the time frame on the graph using the 'Horizontal (Category) Axis Labels' field in the Data source box for the graph...
  7. P

    Dynamic Range applied to multiple charts

    I'm providing a workbook that contains multiple data tables that are each used to create a chart. The data is different, but each table has the same range of weeks for data points. The data tables are 52 weeks in length, I want to create dynamic ranging for the charts in which the users are able...
Back
Top