+ Reply to Thread
Results 1 to 8 of 8

Adding Cell Data to a chart as cell data

  1. #1
    Registered User
    Join Date
    03-01-2014
    Location
    Stoke on Trent
    MS-Off Ver
    Excel 2019
    Posts
    31

    Adding Cell Data to a chart as cell data

    Hi Everyone hope you all all safe at this difficult time worldwide.... i have a chart with data showing my diabetes blood test results and averages, but on a separate data sheet i also have cells that automatically works out how many tests are in a certain range (i.e. lower than 4, between 4 and 12 and then above 12) these change every time i add data to the data sheet. what i want to do is transpose these cells onto the chart sheet so they change when ever i enter data, is this possible. Thanks in advance and keep safe.
    Attached Files Attached Files
    Last edited by Willows59; 04-13-2020 at 05:30 PM. Reason: added sheet

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,469

    Re: Adding Cell Data to a chart as cell data

    Do you mean 'move' or 'copy'? Either should be relatively easy.

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Registered User
    Join Date
    03-01-2014
    Location
    Stoke on Trent
    MS-Off Ver
    Excel 2019
    Posts
    31

    Re: Adding Cell Data to a chart as cell data

    Hi ali sheet attached

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,469

    Re: Adding Cell Data to a chart as cell data

    Thanks, but can you answer the question, too?

  5. #5
    Registered User
    Join Date
    03-01-2014
    Location
    Stoke on Trent
    MS-Off Ver
    Excel 2019
    Posts
    31

    Re: Adding Cell Data to a chart as cell data

    i want to copy the data from the data tab J5 to V5 onto the chart 401-501

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,097

    Re: Adding Cell Data to a chart as cell data

    quick way is to add a chart title. The with the chart title selected goto the formula bar and select required range. =Data!$J$6:$V$6

    If you want more control on the output you can add textboxes and link each one using same method.

    Or you could select the range, use Copy as Picture. Paste the picture on the chart and then use the same range address in the formula bar to link the picture to the range.
    Changes in the cell contents will then be shown in the linked picture
    Cheers
    Andy
    www.andypope.info

  7. #7
    Registered User
    Join Date
    04-05-2020
    Location
    Hannover, Germany
    MS-Off Ver
    MS Office 365
    Posts
    15

    Re: Adding Cell Data to a chart as cell data

    Hi, another alternative is to use Excel Camera tool, it's like taking an instant photo of the selected range and show it in the place where you would like it to be shown.

    Please see attached the example for chart 401-500.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    03-01-2014
    Location
    Stoke on Trent
    MS-Off Ver
    Excel 2019
    Posts
    31

    Re: Adding Cell Data to a chart as cell data

    Problem solved thanks everyone for their help

+ 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. [SOLVED] Adding data to a column based on data from a seperate cell
    By JohnnyBoyxxx in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-14-2017, 01:37 PM
  2. Comparing data between sheets and adding cell data
    By teomi in forum Excel General
    Replies: 3
    Last Post: 12-13-2016, 05:33 PM
  3. Using cell references to construct data ranges in chart data selection
    By rmalliston in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-13-2016, 08:48 PM
  4. need help in adding cell data
    By needurhelp in forum Excel General
    Replies: 2
    Last Post: 12-28-2015, 04:35 PM
  5. [SOLVED] Taking data from a certain cell and adding more data to it in a new cell?
    By JasonBosher in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-08-2015, 03:21 PM
  6. Replies: 1
    Last Post: 10-18-2014, 09:46 PM
  7. Need help with matching cell values and adding another cell of data.
    By mrip in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-18-2013, 04:31 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