Closed Thread
Results 1 to 3 of 3

How do I create interactive charts based on different range of data?

  1. #1
    Forum Contributor
    Join Date
    05-14-2015
    Location
    Ulaanbaatar, Mongolia
    MS-Off Ver
    Office 2021 Professional Plus
    Posts
    120

    How do I create interactive charts based on different range of data?

    Hi guys, hope you are all well.

    Please bear with me since English is not my native language. My day to day work involves some moderate data entry, spreadsheets etc. So what I am looking for is to have a bar data chart that is interactive based on different range of data.

    Example:

    If our company hired 12 new starters (6 expatriate employee & 6 national employees say in March) and another 9 in April (6 expat & 3 national) I want the data chart to pull out this information which i have already entered on another tab of the same worksheet. How would I go about doing this?

    At the moment I am doing everything manually and it's really time consuming as I work on data of 400+ people. If you know a solution please advice and recommend any better improvements.

    Thank you very much. Really appreciate your time & assistance.

  2. #2
    Forum Contributor
    Join Date
    05-14-2015
    Location
    Ulaanbaatar, Mongolia
    MS-Off Ver
    Office 2021 Professional Plus
    Posts
    120

    Re: How do I create interactive charts based on different range of data?

    Bump. Anyone please?

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: How do I create interactive charts based on different range of data?

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.
    HTH
    Regards, Jeff

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 09-29-2014, 10:32 AM
  2. Analysing data based on change range of data including creating charts
    By EagleInsight in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-20-2014, 11:18 PM
  3. Interactive charts
    By espengrafik in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-17-2013, 12:46 PM
  4. Replies: 0
    Last Post: 05-03-2012, 10:54 AM
  5. interactive charts
    By danhenshy23 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-08-2010, 04:22 AM
  6. Interactive Charts
    By daigle in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-24-2006, 01:15 PM
  7. Create Charts based on data in Table
    By MAttenborough in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-11-2005, 07:05 PM

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