+ Reply to Thread
Results 1 to 2 of 2

Create five automatically updating graphs from text & filter these graphs by two variables

  1. #1
    Registered User
    Join Date
    10-21-2014
    Location
    Brisbane, Australia
    MS-Off Ver
    2010
    Posts
    1

    Lightbulb Create five automatically updating graphs from text & filter these graphs by two variables

    In Excel 2010 I have a spreadsheet that holds the various details of employees who have left the company and why they left.

    Firstly, I want to separately create five graphs:
    1) Primary reason for leaving from highest to lowest [text recognition, e.g. career change]
    2) General manager feedback [text recognition of a rating scale across several columns, e.g. agree]
    3) Would work with the company again [text recognition, yes/no]
    4) Things the company could have done to keep employees [text recognition, e.g. higher salary] OR simply the total number of entries as I'm not sure how to make it recognise text strings from sentences of feedback
    5) Suggestions for the company [text recognition, e.g. improve systems] OR number of these things, same reason as above

    Secondly, I also want to be able to filter or create other copies of these graphs according to time and location.
    a) General overview
    b) By location, and optionally by time within each location [text recogintion of location]
    c) By time, and optionally by location in each time period [text recognition of month]

    Thirdly, I want these graphs to automatically update (or be able to be refreshed by selecting a simple button) because the people who will be using the spreadsheet will not have knowledge of how to create graphs from the data when it's time to report the trends to the company. They need to update automatically or simply as new information is entered into the first tab of employee exit details.

    I have managed to do various combinations of these things but can't seem to get them altogether.

    Any help would be greatly appreciated!

    Thanks,
    Gabrielle

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Create five automatically updating graphs from text & filter these graphs by two varia

    It would help if you attached a copy of your workbook so we can use your own data to find a solution. Remember to remove/replace any sensitive data before uploading.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automatically Create Graphs
    By rabidchild in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 04-30-2015, 03:55 PM
  2. Automatically Updating Graphs based on Date
    By JasonMcQueen in forum Excel General
    Replies: 1
    Last Post: 06-09-2014, 01:26 PM
  3. [SOLVED] Automatically create graphs based on specific data
    By Tino XXL in forum Excel General
    Replies: 2
    Last Post: 01-27-2012, 04:48 AM
  4. [SOLVED] automatically updating graphs based upon conditional variables
    By GGC in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-22-2006, 08:35 AM
  5. [SOLVED] Automatically updating Graphs
    By Rich Gibbons in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-06-2005, 09:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1