+ Reply to Thread
Results 1 to 8 of 8

Excel charts using a cell reference or similar

  1. #1
    Registered User
    Join Date
    06-21-2018
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    4

    Excel charts using a cell reference or similar

    Hi

    I would like to know if it is possible to replace a reference number in a chart series to a cell reference.

    Example =$C$(cell ref):$H$(cell ref)

    The plan is to be able to select from a drop down menu and be able to plot a different row based on the request.


    Thanks

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Excel charts using a cell reference or similar

    Hi, welcome to the forum

    There are probably a number of ways to do this
    INDIRECT()
    INDEX()
    Range names

    Maybe if we could see what you are working with, and what you want, we could offere better help?
    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    06-21-2018
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Excel charts using a cell reference or similar

    I have uploaded an attachment, however I'm not sure if it is accessible.

    Hope this helps
    Attached Files Attached Files

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Excel charts using a cell reference or similar

    Sorry for the delay.

    So, what would you want to be able to change the reference to?

  5. #5
    Registered User
    Join Date
    06-21-2018
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    4
    Quote Originally Posted by FDibbins View Post
    Sorry for the delay.

    So, what would you want to be able to change the reference to?
    Sorry, meant to explain.

    The time is a drop down menu. When it is changed, the number below the chart changes to a different cell reference (row) number. I would like the chart to alter the plotting to that row.

    Thanks.

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Excel charts using a cell reference or similar

    See if the following does what you want:
    1) The formula that populates C19:CQ19 on the Graph(2) sheet is:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    2) The chart reads the data from C19:CQ19 on the Graph(2) sheet. Note that this row may be moved and/or hidden for aesthetic purposes.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  7. #7
    Registered User
    Join Date
    06-21-2018
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Excel charts using a cell reference or similar

    Thank you that was brilliant.

    Never thought of adding a new line to show the calculation and then referring to that

  8. #8
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Excel charts using a cell reference or similar

    You're Welcome and thank you for the generous feedback. Please take a moment to mark the thread as 'Solved' using the thread tools drop down in the ribbon above your first post. I hope that you have a blessed day.

+ 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. Reference for charts of powerpoint in excel VBA
    By vibhor in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-26-2015, 11:25 AM
  2. Reference for charts of powerpoint in excel VBA
    By vibhor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-20-2015, 01:34 PM
  3. [SOLVED] How do I add a reference line to Excel charts?
    By roswellmike in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 06-04-2015, 01:57 PM
  4. Replies: 2
    Last Post: 11-27-2013, 12:06 PM
  5. Coding to Create similar charts for Range of coloumns
    By montego in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2010, 01:05 PM
  6. multiple charts similar size?
    By [email protected] in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-10-2006, 01:20 PM
  7. quick charting question for similar charts on multiple sheets
    By Boon8888 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-27-2006, 03:40 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