formulas in charts

  1. mikecox39

    Automate date range entry

    I'm the treasurer of my HOA. I created a budget spreadsheet that works well but I will be giving up the position a some point so I want to create a Dashboard for the person who takes over for me, to make it "user friendly". Every year I have to start with a new sheet, changing the dates...
  2. T

    Creating a Dynamic Chart Combining If/Then Statement and Offset Formula with Named Ranges

    I have two worksheets in a workbook (WellbeingDashboard); Charts and Data. The data I am looking at includes product data (five products), accounts and user metrics (two metrics), by state (two states). I am trying to create a single chart (stacked area) that trends the change in a user-selected...
  3. C

    Making a table Macro More efficient

    Hey everyone I'm using this code to make a table for a graph to update by selection of data but I'm using a very inefficient method to do it. it works but I am wondering if there is a better way. Range("B22").Select ActiveCell.FormulaR1C1 = _ "=(COUNTIFS('Hidden graph...
  4. S

    Chart Help: Line graph to only use certain rows if specified name appears in row and ignore rest of data, line graph to Update automatically with any

    Hi everyone, I have a spreadsheet in which I have created a line graph from containing 9 columns and a few hundred rows so far of data. Example below - (please note managers can have multiple scores on any one day and different managers can be audited on the same date) Date; Area; Event...
  5. P

    Creating Formula for Pivot Tables

    Hi everyone, I'm new here and am having some problems. I want to create a pivot table for work that tracks calls, contacts, email, voicemail, and meetings and track ratios for employees. The problem is that all of that information is contained in 1 column, and I can't figure out a formula to...
  6. B

    Using Formulas for Charts

    Using Excel 2007, I need to update numerous charts on a monthly basis. All data is contained within 1 workbook with numerous worksheets. The charts present information from multiple worksheets. I am searching for a way to use a formula that defines the number of data points being charted...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top