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

Recent content by ellistyle@gmail.com

  1. E

    Append "form" inputs to a query

    I have a "form" whose function is to gather qualitative input. Quantitative data is prepopulated and if certain criteria are met, a comment is to be entered. Here is a simple representation of the form data. Column D is what I want to capture and archive. Form data from 5/1/22 Product...
  2. E

    Actual and Forecast from Different Tables

    Just to check back in--I believe I figured it out. I do need to merge tables. I have a set of products each with monthly forecast dates and separate production dates. Adding those separate date fields to a pivot table does not work as I had hoped.
  3. E

    Actual and Forecast from Different Tables

    Yes--ultimately the intent is to pivot. I don't necessarily want to merge tables--just merge in a pivot so I can drop in a product and see actuals back 12 mos and forecast forward 12 mos. Thanks for the response!
  4. E

    Actual and Forecast from Different Tables

    I am just getting started with Power Query. I have 3 tables: Product ID Actual Sales Forecast Sales Actual Sales has historical actual data by product by month. Lets say the data goes back 12 months. Forecast has monthly data by product going forward 12 months. Product ID has the product...
  5. E

    Use of Secondary Axis

    I have several horizontally oriented charts in a simple dashboard sheet. In some cases there is only one data series. Is there a way to duplicate the primary axis markers in the secondary axis. Alternatively, is there a way to display the axis markers to the secondary axis when there is...
  6. E

    Default Currency Format

    Hello. Thanks be to Chandoo.org. It is as helpful as Excel itself. I am now using Excel 2010. My preference for currency formats is accounting format with no symbol, 2 decimal places with the comma separators. Can I make that the default format when I hit the $ in the ribbon? As it...
  7. E

    Subtotal Function Across Horizontal Cells

    I have built a sheet with client accounts in cells A2:A5000. Starting in column E & F, I have monthly sales and gross profit for each client. E&F is December, G&H January, I&J Feb....AE&AF Jan'10. After column A there are total sales & total profit columns. I want to use the subtotal...
Back
Top