+ Reply to Thread
Results 1 to 2 of 2

Changing Chart based on Cell entry

  1. #1
    Registered User
    Join Date
    05-29-2021
    Location
    Lebanon Junction, Ky.
    MS-Off Ver
    2016
    Posts
    21

    Changing Chart based on Cell entry

    Is there a way to change the chart data based on a cell input? I am trying to have a chart change to show the current months data when I enter the month in an assigned cell. When I enter a month in cell A1 on the first sheet I want the data for that month to show in the chart.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Changing Chart based on Cell entry

    named range for each month:
    January ='ECI Charted Issues 2021'!$L$3:$L$67
    February ='ECI Charted Issues 2021'!$Y$3:$Y$67
    March ='ECI Charted Issues 2021'!$AL$3:$AL$67

    data validation for QG sheet, a1 list, refers to: January, Feb...December

    copy chosen month data to chart sheet column B1:B67

    Please Login or Register  to view this content.
    hide column B
    select chart data: ='Quick Glance'!$B$1:$B$67, option show hidden rows and columns.
    Attached Files Attached Files
    Ben Van Johnson

+ 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. Replies: 17
    Last Post: 10-16-2017, 04:37 PM
  2. [SOLVED] Changing color of Tabs based on cell entry
    By $mart Group in forum Excel General
    Replies: 2
    Last Post: 03-11-2017, 04:51 PM
  3. [SOLVED] Changing the fill color of a portion of a pie chart based on a cell value
    By sungen99 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-29-2016, 11:20 AM
  4. Changing chart based upon a cell ...
    By reglook0736 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-20-2015, 11:18 AM
  5. Dynamic Chart(s) that pick up isolated data based on cell entry
    By ObiWanBaloney in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-07-2012, 05:42 AM
  6. Changing the legend of a chart based on a cell value
    By bhokalivarun in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-06-2009, 11:15 PM
  7. Changing a cell color based on date entry ...
    By T. Denford in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-26-2005, 02:51 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